Updating Multiple Tables

[Mongooseman]

Earlier this summer I was tasked with fixing a database used by the purchasing department where I work. I didn't know a lot about databases, but I learned pretty quickly. The tables--which were horrendous--are now normalized, but I'm having trouble getting data into them.

My workplace still uses Access 2000, and I cannot find a lot of good books, tutorials, or documentation on this version. I can make basic forms and queries, but the new database requires me to view and manipulate data from several tables at once. The main form of the old database used one table. A form with similar functionality (as my boss requested) will use at least ten. I'm having trouble using even two.

For example, the Parts table contains data about a part that can be ordered. The fields include an ID, a description, a QA person, OEM numbers, and RDM (in-house) numbers. A single part can be assigned multiple OEM and RDM numbers, so those are two separate tables with a one-many relationship to Parts. QA Person is also a foreign key linked to a separate Employees table.

I cannot figure out how to update the Parts table, the OEMNo table, and the RDMNo table in the same form. I've played with queries, subforms, and even VBA, but all efforts have led to a dead end thus far. I cannot find any useful tutorials or guides. Please help.

 

[HiTechCoach]

Sounds like a basic sub forms should work by just setting the master and child linking field properties.

I would recommend checking out this tutorial:

Access Basics

and this example that shows how to use sub forms and goes with the above:

Contacts -- Names, Addresses, Phones, eMail, Websites, Notes

Hope this helps ...