Subforms input.

[UponFrail]

Okay guys, I've got my structure sorted out. The aim is, to be able to add contracts, for both New Customers, and Existing Customers.

So the input for this, according to my fellow students and teacher, should be my, CustomerTBL and my ContractTBL. With the ContractTBL being the subform.

This works fine, it shows all contracts, of the individual customers. Right the major problem is, i need to be able to add records as well. Which i can't do in the subform.

I'm stuck on this part, i need to be able to add, a new contract, for both, new customers, and existing customers.

Anyone got any suggestions? Thanks in advance for any replies.

 

[MStef]

What is the Primary key in both tables, what is the foreign key in CustomerTBL, what is the Relatioships ????