form design question

[hilz]

Hi.
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

 

[Guest]

Your subform should work, when creating your subform it should ask you how
you want to manage the relationship and it will usually give you the name of
the fields to link together or an option to create your own. If you didn't
do that, when in design view of your main form, click on the subform (the
furthest outer edge) and goto properties, then data tab. Here you can link
your child and master fields.

HTH

 

[hilz]

Hi.
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

no takers?