Thanks
Thats exactly what I have done
So once I have Artist & Genre tables linked
What about the member and user tables, how do they connect up?
I have tried every possible way to link them so that when I create a form to test it, I put every record onto it from all the tables so I can fill in...
I am currently desiging a site with a directory which I am building in access. I am using ASP/ODBC to connect to it and define filtered recordsets for live binding and displaying my data
SELECT ArtistID, ArtistName, Genre
FROM Artist, Genre
WHERE ArtistName LIKE 'varArtistName' OR Genre LIKE...
I have four tables User, Member, Artist, Genre all with primary keys like so UserID, MemberID, ArtistID, GenreID and fields which are relevant to the table
UserID MemberID ArtistID GenreID
UserName FirstName Name Genre
Password LastName Link...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.