I'm still unsure about foreign keys..even after reading the doc file and Paul Dubois 3rd edition
My doubt is...how much constraint is applied.....( probably a bad explanation) If i have a table 'Customers' with the primary key being 'CustID' Then i have a table 'LastVisit' with a foreign key 'CustID' btw...i have a Form-SubForm in OO that i'm working with where i have the 2 tables linked should the foreign key 'LastVisit.CustID' only allow values that are in the linked primary field? or will it allow any value that is in the table ' Customers.CustID' ? When i enter any value that doesn't exist in the 'Customers.CustID' column i get the ref. integrity error...BUT i want it to kick ANY value that doesn't relate to the linked parent table out as an error. Pretend i didn't mention OO. -- Grass Cake
