Access subform wont save for each main record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a subform in access that is a maintenance record of an asset.
The asset is input once(main form) and data is entered into the subform each
time anything is done to the asset. But the db wants me to link either date
or id to link them, if i use date then i can only add things on that date or
they dont appear anywhere, if i use id, it only works on one record uding the
auto number.

Can anyone help, i have done this before but can't work out what i did.
 
Each Asset should have a primary key ID, use the auto number field for this.
The table that your subform is based on should have a number (Long Integer)
field that is the foreign key to the Assets table primary key.

These are the fields you would use to link the subform to the main form.

Steve
 
Thanks Steve,

Everything i read said this should be automatic!!!!!!!!!!!!!!!!!!
But all good now, thanks.
 
Back
Top