Relashionship

[Fady01]

Dear all,

I'm working on a project which is on a transport company. I have two tables :

demand
No client Auto
firstname Text
lasname Text
adress Text
city Text
ZIP Number


recipient
No recipient Auto
No client Number
firstname Text
lastname Text
adresse Text


relashionship :

demand 1__________________n recipient


As you have notice one demand can have many recipient.


In order to perform this, I have created two forms:

demandform and recipientform.

On the demandform I have added a button which open the recipientform.

The issue that i'm encouterring is : the recipientform don't get the foreign key.

Does anyone can help me to solve this issue?

thank in advance.

Access version : 2007

 

[Galaxiom]

The easiest way is to add the Receipient form to the Demand form as a Subform.
Then set [No client] as the Link Master Fields and Link Child Fields property of the subformcontrol.