Help with simple design

From your screenshot it looks like you have created a database for each table. All of your tables should be in one database.
Yeah, I think I am still learning so I am likely not 100% sure of what I am doing. I am taking all the help into my brain and then letting it settle. Then doing the research on key words that may be the answer to my confusion. If you read from the beginning I started with a flat file file database and wanted to complicate it and make it relational. So I broke it up into what I thought were other tables but as you point out they are other databases? I just wanted to relate the others to make it better to search specific data. Someone mentioned look up tables for searching and maybe I didn't understand what look up tables are. I am still learning...
Edit: Now that I thought about it, I had already set this up in LibreOffice and did in fact have multiple tables. I just bought and installed ACCESS a day or two ago and was going to use that to learn with more help available. For some reason I created all the other tables as new database so I need to go fix that. I must have missed that option from the start menu so I will have to find where to do that. Thanks for noticing and pointing that out. :)
 
Last edited:

Users who are viewing this thread

Back
Top Bottom