Creating More Than One Form and Table - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Creating More Than One Form and Table

Shelley Sanford

10 months ago

I am working on a personal project of mine and the data I am working with is all the same but at the same time it is different.
For example:
Starship Weapons (War supplies) takes 5 different Arms assembly components and those each take 3 different materials to craft them.
Then Armored Vehicles takes 5 different products.

My question is should each set of data have its own tables and forms?

Thank you so much in advance,
Shelley Sanford

	Raymond Spornhauer @Reply 10 months ago
Shelley I would recommend this video: https://www.youtube.com/watch?v=vyr55lZ3CzY

Juan Rivera @Reply

10 months ago

take a look at Richards Helper Table where he puts many small tables into a form then when you get rdy you can set up the form and change colors to background and even display difrent graphics with the power of VBA. I think this will give the look of diffrent forms but in reality its the same one. Also keep in mind that there is a 100 diffrent ways to do what you wish in Access the main point is to get the results that you wanted. both way is not wrong and the best way is the way you want it. makes you think about it...
Helper Data

	Juan Rivera @Reply 10 months ago
WOW Raymond beat me to this one....LOL

	Shelley Sanford OP @Reply 10 months ago
Thank you both so much. I also realized after I posted this, I had to keep the data separate since it was showing different things related to the same component. I actually got the forms and tables to reflect what i needed them to do! Thank you guys so much for your help

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View