form design question

  • Thread starter Thread starter hilz
  • Start date Start date
H

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
 
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 said:
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?
 
Back
Top