data entry in subform - fk doesn't undertake value of pk

[LeeAnne]

Hello!

I have a problem with my fk's behind the main form. Here is the situation:

Table PERSONS is behind the main form and table BANK_DETAILS is behind the subform on a different tab. There is a one-to-one relationship between PERSONS with FK_ACCOUNT_CODE and BANK_DETAILS with ACCOUNT_CODE as pk in autonumber format.
When I added a new Person in the main form and I switch to the tab for the bank details, I can add a new record in BANK_DETAILS, but the value of the pk ACCOUNT_CODE would not be passed through to the fk in table PERSONS.

I am not good at programming! So what could I do?

I would be very grateful about suggestions! Thanks!

[Rabbit]

Check the parent/child properties of the subform control.

[LeeAnne]

parent/child fields are linked. Nothing happens. Is there a possibility to write a setvalue statement for the pk control, maybe as after update event? can anybody help me with that, because I am not good at programming?

Thanks!

[Rabbit]

I think you've got it backwards, the primary key should be in the main form while the foreign key should be in the subform.

Rather than linking the two tables on account id it should like on a person id. The way that parent/child fields work is that the field in the parent table populates the field in the child table. You should either flip the tables or change the primary key field.

[LeeAnne]

Thanks for the answer!
I think I'm gonna try to switch the keys. Just one more question: might it have something to do with the tab control? I've got the tab control on the mainform and the subform is on the 2nd tab.

[LeeAnne]

Alright, thanks for the answers! I changed the keys and everything is working fine!

[Rabbit]

The tabs don't affect controls in any way other than which are visible depending on the tab you're on.

Subforms were just set up to work with the main form populating the linked field on the subform and not the other way around.