AnsweredAssumed Answered

Related Tables in Browse mode...

Question asked by jasonperl_1 on Jul 23, 2010
Latest reply on Jul 23, 2010 by philmodjunk

Title

Related Tables in Browse mode...

Post

I am currently working on a solution where every "customer record" (table 1) can have many "vehicles" (table 2). I have formed a one-to-many relationship via a primary key, an auto-entered serial number in table 1 called customer_ID to a foreign key in table 2 also called customer_ID...

I thought that by creating this relationship that when a record was created in the "vehicles" table it would automatically insert the customer ID from the "customer record" table... Furthermore, I hoped when viewing a record in the "customer record" table if I went into the "vehicles" table it would only display the related records... Instead it is like they are two completely separate databases... I am still having to input the customer ID generated in the "customer records" table into the "vehicles" table... and even then I would have to perform a find to display only the related records...

Is there a way that when I search in "table 1" that will automatically only show related records (with the same customer ID) in table 2?

Sorry if my question is rather basic... I'm rather new at this... Thanks for the help.

Outcomes