Data entry using linked forms

[Trevor Howard]

I need to enter data into two tables using two linked forms (“Goods In” form and a linked “Products” form). My primary key is grnID in “Goods In” & foreign key is grnID in “Products”.

My problem is, If I click to “Products” from “Goods In”, the foreign grnID is blank so will not store data without first entering the grnID manually. I have created a “Goods In” form and “Products” as it’s sub form, and the grnID is atomically then displayed in the sub form allowing data input, but I would prefer linked forms.

Any suggestions? Using Access 2000. Sorry for the long description, I am new to Access and have no VB skills sadly. I have been using the wizards to create my forms. I hope someone can sort me out! Thanks for your time. Trevor

 

[Dgavilanes]

your relationship is not correct.
Is the second form nested within the main?

On the main form your MainID (Autonumber with a primary key)
and the second form (subform ID ) is a number.
If you have problems let me know for second option. send a copy so I could see it, first try it yourself
Dennis

 

[Trevor Howard]

Dennis, Thanks,
I have since my posting found the sub form layout will probably be better for my application and it seems to work. I still cant get linked forms to function though!. It will be great to have your thoughts why as I will run into this again so I attach this part of my db. Thanks again! Trevor

 

[Trevor Howard]

Sorry, db didnt attatch, trying again