Need help using same form to update different tables.

[rogle]

Form 1 has a combo box that shows a Field named SerialNumber from Table SN. There is also a Table named identical to each item in table SN. What I want to do is select a Serial Number from Form1 and have it open up a generic form which will show data from its corresponding table. I've tried using Recordset and Record source to change the generic forms source with no success. I believe this is probably easy to do but I just can't figure it out.
Any help would be appreciated.

 

[JeremyNYC]

rogle,

The problem is not your form but your table structure. What you should do is combine all of the other tables you mentioned into one table, adding a field to hold SerialNumber. You'll use that field to distinguish between each of the groups of data that are now in separate tables. This will make your life MUCH easier.

There's a whole set of theories about this called Data Normalization. There's a great paper on this subject, not written by me, on my website. Get to the Developers' Section and choose the "Fundamentals of Relational Database Design".

If you want to briefly describe the data you want in your database, I'm sure you'll get some ideas for how to organize your data.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.