Access subform wont save for each main record

R

Rob W

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.
 
S

SteveM

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
 
R

Rob W

Thanks Steve,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top