i am trying to get the foreign key field in my join table autofilled with the primary key field in my WB table
[IMG]file:///C:\Users\astange\AppData\Local\Temp\msohtmlclip1\0 1\clip_image001.png[/IMG]
i am trying to get the foreign key field in my join table autofilled with the primary key field in my WB table
[IMG]file:///C:\Users\astange\AppData\Local\Temp\msohtmlclip1\0 1\clip_image001.png[/IMG]
This would need to be a form/subform arrangement where the field you want autofilled is in the Link properties of the subform.
yes, in the subform properties ,set them to the key field:
LINK MASTER FIELDS: ClientID
LINK CHILD FIELDS: ClientID
this will fill in the ID automatically.
I would need some help creating this form etc
Create a form using the wizard for your main table, the "one" side of the join. Get this form working the way you want to handle the records in that table - adding, updating, searching, etc.
Then create a form for the WB table, usually a tabular or continuous form. Close and save it. Then select the subform icon in the Design of the first form, a wizard will come up asking you which field(s) you want to join on. That will fill in the Link properties for you.
Now when you are viewing a record on the main form, its corresponding records will be displayed in the subform. And when you add a new record on the subform the key field (link field) will automatically be filled in.