Updating tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have three tables
(1) A database containing customer details and the primary key is customer
name.
(2) A quotation table with quote number (Auto no) and price and other
details. Quote number is the primary key
(3)The third table is a link between the above mentioned tables with contact
names (drop down from table 1) and quote number from table 2. Both fields are
primary keys.

I have prepared a form with name selected from third table and quotation no
selected from second table. I am either unable to select a name from the drop
down list or when I do, only information is updated on the quote table and
not on the third table. I will be grateful if someone can give me some clue.
 
The "linking table" method is used for a many-to-many relationship. While a
customer can have more than one invoice, can an invoice have more than one
customer? If not, then add a field to the invoice table for the CustomerID
field and link the two tables on that field, skipping the third table. While
we're on it, customer name may not be a good primary key. Would it be
possible to have two customers with the same name?

The above scenario, using 2 tables instead of 3, will also lend itself to a
form/subform setup where the form would have the customer information and
the subform would have each of the customer's invoices.
 
Back
Top