Hi Everyone, I am working on a m

[karren]

Hi Everyone,

I am working on a mailing list where one table (artistnames)holds all the music artist's names and artistnameID, which are displayed upon registering for the subscriber to choose from. Another table (newsprefs) holds the subscriber's email address with the subsciber's mailing list preference (artistnameID, which is beside the person's email address).

once a user is registered, they can change their mailing list preferences by logging in and editing their existing info.

my problem is that i want to display all those artists in the artistnames table which the user has NOT subscribed to, so that they may have the option of subscribing to those artists if they want to.

does any body know how i would go about doing this?? if you need more info, just let me know!!

thanks everyone for your help!

 

[GaryC123]

This is a suggestion and they may be a better way.
Create a table to hold the member id and their music selections as individual records.
Then use a select statement something like this

SELECT * FROM ArtistNames
WHERE ArtistID NOT IN
(SELECT ArtistID,MemberID FROM MembersChoice where MemberID = " & memberid & "'&quot
Saturday 12.00

20.00

3.00am

Sunday [img http

 

[karren]

thanks gary! i will try this out and let you knwo what happens