Link Forms

[GORE]

Hello everybody,

I have one dbase with 3 tables wiht 3 forms. One is "custonmers" , "glass" and "lens".

Customers - CusID as primary Keys
Glass - GlasID and CusID primary keys
Lens - LensID and CusID Primary Keys

When I change a specific field (only) I am losing the records on the other tables of the specific customer.

Thanks in advance
xxx ΠΑΟ ΘΡΗΣΚΕΙΑ ΘΥΡΑ 13

 

[Rich]

CustID is the Foreign Key in glass and lens tables

 

[GORE]

CustID is the Foreign Key in glass and lens tables

How can I set the fields as Foreign keys, is there any option ?