View Single Post
  #8  
Old October 19th, 2004, 04:25 AM
Jeff Boyce
external usenet poster
 
Posts: n/a
Default

Marc

(see in-line comments)

Thank you for your advices Jeff, I will try to focus how better normalize
the tables, since I like the perfect things. Nevertheless, there is still
something that I don't understand.
If I make a related Customers table with a Samples one, how can I manage

all
this in a form? Using a subform?


If you have a customer with multiple samples, a common approach is to put
the customer information in a main form, and the related samples information
in a subform.

And all the other fields, such Shipping
Date, Continent, Country, Courrier, AWB, Reference, GrossWeight, and so on
... using an other subform?


If I understand your data structure, there are only ONE of each of these per
customer, so you wouldn't need to use a subform. These data elements, based
on your customer table design, only happen once.

There is one thing that I'm still puzzled about, however. Based on your
design, it appears a given customer has one and only one ... ?Order? I
can't tell how the samples relate, but I'm wondering if you are dealing with
a situation analogous to one with multiple customers, and each customer can
have multiple orders, and each customer's order can have multiple ...
?samples?

--
Good luck

Jeff Boyce
Access MVP