H
hilz
Hi.
I asked this question before, and did not get any answers.
I hope someone will answer me this time!
I have the following two tables:
CONTRACT
********
ID (primary key)
CUSTOMER_ID1 (foreign key)
CUSTOMER_ID2 (foreign key)
CUSTOMER_ID3 (foreign key)
AMOUNT
some more columns...
CUSTOMER
********
ID (primary key)
NAME
some more columns...
I have a relation many-to-one from each of the three
CONTRACT.CUSTOMER_IDs to CUSTOMER.ID.
So each contract can have up to three customers.
I am having trouble displaying the customers in a contract form.
I tried with a subform but that does not work.
what can i do to display those three customers in the contract form?
thanks
I asked this question before, and did not get any answers.
I hope someone will answer me this time!
I have the following two tables:
CONTRACT
********
ID (primary key)
CUSTOMER_ID1 (foreign key)
CUSTOMER_ID2 (foreign key)
CUSTOMER_ID3 (foreign key)
AMOUNT
some more columns...
CUSTOMER
********
ID (primary key)
NAME
some more columns...
I have a relation many-to-one from each of the three
CONTRACT.CUSTOMER_IDs to CUSTOMER.ID.
So each contract can have up to three customers.
I am having trouble displaying the customers in a contract form.
I tried with a subform but that does not work.
what can i do to display those three customers in the contract form?
thanks