Connect tables to form

[alishay]

I am a Novice. But it seems this shouldn't be as hard as it is. Want to create a Form for data entry where most of the Fields will have information that is already entered in tables, except for one, or a second one for comments. Sort of like the Inventory templates--but they don't quite fit. Many books or other items, by the same author/composer(s). I've created a Table with everything I want. But then I did some reading, so now I have 15 different Tables, because it seemed I should have everything in individual Tables. So so I need one with everything, or one with the author names, and a second Table with the number of pages, and another Table with Year Purchased, another with Favorite-Yes/No, etc. ? Another with Version, etc. If so, that's fine. I want the Form to have drop down lists for all of them--so that everything matches when it comes to querying. The title of the book is the only thing (and comments) that envision would be manually entered on the Form when I purchase new books by the same author (for example). But how do I connect them so that I can create a Form? I've been reading about relationships and primary keys, but I'm still confused. Can someone help? Thanks

[davegri]

Tell us what you want the database to accomplish for you.
Don't use database terms or jargon, just an explanation of what the database is to do.
It seems you want to create a database of authored material with ability to search it over many conditions?

[alishay]

I am a Novice. But it seems this shouldn't be as hard as it is. Want to create a Form for data entry where most of the Fields will have information that is already entered in tables, except for one, or a second one for comments. Sort of like the Inventory templates--but they don't quite fit. Many books or other items, by the same author/composer(s). I've created a Table with everything I want. But then I did some reading, so now I have 15 different Tables, because it seemed I should have everything in individual Tables. So so I need one with everything, or one with the author names, and a second Table with the number of pages, and another Table with Year Purchased, another with Favorite-Yes/No, etc. ? Another with Version, etc. If so, that's fine. I want the Form to have drop down lists for all of them--so that everything matches when it comes to querying. The title of the book is the only thing (and comments) that envision would be manually entered on the Form when I purchase new books by the same author (for example). But how do I connect them so that I can create a Form? I've been reading about relationships and primary keys, but I'm still confused. Can someone help? Thanks

Thank you for responding. Basically, I want to put all my sheet music/music books in Access. I had purchased software specifically for that many years ago, but they stopped supporting it many, many years ago. So now I want to do it in Access so I don't have to be concerned with support.

I would like to create a Form that allows me to select the Composer, Arranger, Performance Time, # of Pages, Key Signature(s), Voicing (Organ, Piano, Piano/Organ, Vocal, SSA SSA, SATB, etc), Favorite, Season (Christmas, Easter, Patriotic, Wedding), Collection Name (if music piece is in a collection versus single) # of Copies, Favorite, Comments, Last Date Used and there are a few others. These would be available to choose from when manually entering the Title. And yes, I would like to be able to search for a particular piece by Last Date Used, or Composer, or Season, etc.

[ssanfu]

It sounds like you have "Normalized" til it hurts......
I would not expect a (look up) table for the number of pages, nor the year purchased, nor for Favorite-Yes/No.

You could post your dB for analysis.


Maybe is would help you to work through these tutorials. You actually have to do the tutorials, no just read them.
http://www.rogersaccesslibrary.com/forum/forum46.html

[alishay]

Thanks I'll take a look at the tutorials.