I have a header table and a detail. The header contains all the summary information for a particular Form. I have the detail just for that, the detail. The autonumber in the header table is the foreign (fk) in the detail table. What is the best method to update the autonumber in the header table to the detail table. This is going to be a muli-user database...
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
? Best Method / Header & Detail Table
- Thread starter pcdaveh
- Start date
quite a number of ways to do that. Create a query to use under your form for your details entry and in the criteria for the fk put in Forms!HeaderForm!Number... you can use the linked form wizard.... if it's in a subform... use the masterlink and childlink properties...any one of those will work..
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question