I have two DB
CD
CD Group
CD Name
Cd Artist
CD Tracks
Hymnal
Hymnals Song
Name of Hymnal
Author Key
Composer
I want to have a form to see if what song if they are on a CD or Hymnal or both
Shouldn't I have one big table for all the data for name of song, author, hymnal, or cd? And have a subform for the cd tracks? This is getting allitle difficult for me
I want one form to search and have two or more combo boxes
Displays from
Name of Song (1st list box) and matches up from both tables
Author or composer (2 list box)
Shows up on Hymnal or and CD (3 list box.)
In each table I do have a field for Media Type which is Hymnal or CD/Both
I know how to set up the tables, just need some help with the coding on the list boxes.
How do I set this up?
All in one DB form or start a New DB It would seem easier to have it all in one file.
I can attatch a screenshot or file so you can view it to make life easier?
CD
CD Group
CD Name
Cd Artist
CD Tracks
Hymnal
Hymnals Song
Name of Hymnal
Author Key
Composer
I want to have a form to see if what song if they are on a CD or Hymnal or both
Shouldn't I have one big table for all the data for name of song, author, hymnal, or cd? And have a subform for the cd tracks? This is getting allitle difficult for me
I want one form to search and have two or more combo boxes
Displays from
Name of Song (1st list box) and matches up from both tables
Author or composer (2 list box)
Shows up on Hymnal or and CD (3 list box.)
In each table I do have a field for Media Type which is Hymnal or CD/Both
I know how to set up the tables, just need some help with the coding on the list boxes.
How do I set this up?
All in one DB form or start a New DB It would seem easier to have it all in one file.
I can attatch a screenshot or file so you can view it to make life easier?
