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
|