Form field to update two tables?

[LMA]

Hi, I'm new to Access and trying to improve my company calibration database. We have been using the tables directly and I want to set-up a form to enter the data.

The tables look like this:

Gage Master Table: (only one row allowed per Unique Identifier)
Unique Identifier; Status; Description; Date of Calibration; Next Calibration Due Date; Gage Accuracy; Team; User/Location.....

Calibration Results Table: (multiple rows for each Unique Identifier as results are added)
Unique Identifier; Date of Calibration; Next Calibration Due Date; Dimension 1; Dimension 2 - 10; As Found; As Left.....

Currently I have a form that will update the Results table, but I need it to also update the Date of Calibration & Next Calibration Due Date in the Master table for the Unique Identifier entered in the form. How can this be done?


I would appreciate any help in making this work.
Thanks.

[Robeen]

I recommend using a Form with a SubForm - aka - Master-Detail Form.
See if this page helps with what you are trying to do:
http://office.microsoft.com/en-us/ac...010098674.aspx
All the best!

[LMA]

I was able to create a sub form, but the dates have to be entered twice, once for the Results table and again for the Master table. Is there a way to link the date boxes so one entry will update the other?

[Missinglinq]

The Link Master Fields/Link Child Fields properties can take more than one set of Fields; simply include the Date Fields as well.

Linq ;0)>

[LMA]

Thanks for the tips, they helped. I had another issue with updating the master table and finally found a solution. Still have much more to do, but at least I'm making some progress.