error "related record required in table"

[shez]

I have my table structure as:

personalDetails(Pid, fn, ln,...)
link(pid,addressId, type)
address(addressId, street...)

I have a form called add participants. It has a subform which gets the addresses of each participants.

It works ok for an example record that i created using tables but when i tried using form i can enter everything except for the address.. when i try to click on the subform to enter an address I get the error

"related record required in personalDetails table"

the subform is created using form wizard and the fields that i am taking are: link.pid, type, street

and then when the wizard asks me how i want to link them i use: personalDetails.pid & link.pid!

 

[Uncle Gizmo]

Access is designed to handle the relationships between your main form and your subform automatically.

The table within your subform must have a field which is identical to the ID field on the main form and these are the two fields that should be linked together, it looks to me like you are linking in a different field.

 

[shez]

Access is designed to handle the relationships between your main form and your subform automatically.

The table within your subform must have a field which is identical to the ID field on the main form and these are the two fields that should be linked together, it looks to me like you are linking in a different field.

Hi

Thanks for the reply BUT i have stated that in the subform I have pId which is the same field as the one in the main form..

The funny thing is that when I added a record manually i.e. entered data through TABLES and then looked at the form, it worked ie the subform had data relating to that record.. the problem only occured when i tried adding data through the form :s

 

[boblarson]

post a screenshot of your relationships, if you can.

 

[shez]