Autonumbers again

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

My problem is that I have a master table (tblproject)
linked to two other tables (tblsubcontractor,
tblmilestones). I have used ProjectID to link all tables.
In the master ProjectID is an autonumber and long integer
in other two tables. SubcontractorID and MilestoneID are
autonumbers in the other two tables. These ID fields do
not contain relevant project data and are thus hidden.
I wish to enter all new data via 3 forms based on these
tables. But how to I get a number into ProjectID fields in
the Subcontractor and Milestone tables? (an autonumber
would be great but not possible to use?)
thanks (hope this is understandable)
 
If I understand you, make the subcontractor and milestone
forms as subforms on the project form. Link the forms
with ProjectID.
Roxie Aho
 
Back
Top