Any one use Access Database?
Hopefully there are some that use Access as I am trying to set up a database and have a question. The database is CASSETTE TAPE COLLECTION. I have 20 columns starting with ID, TITLE OF CASSETTE, S...
Forum Discussion
Hey guys, thanks for all the info. I tried to take all into consideration and this is what I came up with:
Table 1 Cassette Info Data
Junction table between table 1 and table 2
Table 2 Song Names Data
Junction table between table 2 and table 3
Table 3 Name of Artist Data
Kind of a bear setting up relationships between these so hope I got it right.
Form for cassette info data
Form for song name data
Form for artist name
I have started to enter data and all is going well with the 3 forms. Have to enter each song and artist on the cassette even though one may already be in the database under another cassette. I tried to make one form but Access indicated too many items for one form.
Still have to set up queries and reports. Could not have gotten this far without y'all s (or is it youse guys?) help. Thanks!!!
Wayne
Table 1 Cassette Info Data
Junction table between table 1 and table 2
Table 2 Song Names Data
Junction table between table 2 and table 3
Table 3 Name of Artist Data
Kind of a bear setting up relationships between these so hope I got it right.
Form for cassette info data
Form for song name data
Form for artist name
I have started to enter data and all is going well with the 3 forms. Have to enter each song and artist on the cassette even though one may already be in the database under another cassette. I tried to make one form but Access indicated too many items for one form.
Still have to set up queries and reports. Could not have gotten this far without y'all s (or is it youse guys?) help. Thanks!!!
Wayne
