I am struggling with something. I have a main form, called assets. It contains a part number, description and cost.
I have a subform under it, called asset breakdown. It contains quantity, date received, and warehouse location. I created another lookup field, called “link to asset”, to tie the two forms together; via “link to asset” and “ID”-primary key, in assets.
What I want is to have “link to asset” in the subform to automatically to be filled in with the ID-primary key, from ‘Assets’. When I enter into the subform, I need to manually add the ID for that asset, in the drop down box.
To summarize:
Main Form and Table--‘Assets’: ID part number description cost
Subform and Table—‘Asset Breakdown’: ID quantity date received location link to asset
I want to link: ‘Assets’:ID to ‘Asset Breakdown’:link to asset – automatically, without having to enter it.
I have the appropriate relationship set up. I'm very stuck.
Thank you!