I would like to update certain fields on two different tables from one form. I would like to have a dropdown to select a part number and then update related fields to that part number while not adding the part number again to the tables. I just want to update certain fields of that part number. Can anyone please advise on how to accomplish this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Update two tables from one form
- Thread starter netrusher
- Start date
NXMold
Technical User
- Jul 22, 2008
- 104
What fields from what tables, what is your table structure?
Is it a one-to-one relationship, many to one? If its one to one, you could just make a simple query to use as the source of your form. If its one to many, you might use a continuous sub-form.
Is it a one-to-one relationship, many to one? If its one to one, you could just make a simple query to use as the source of your form. If its one to many, you might use a continuous sub-form.
- Status
Similar threads
- Locked
- Question
