[Cut]
Jeff, thank you in ansering me and for you frankness. The database is
composed with 6 tables. In the satellite tables
(continent, country, customer, packing, courrier) I insert *only one time*
all the data available and then in the DataEntry Form these data are
filtered
and recalled by comboboxes.
The tables a
[tblContinent]
idContinent - text (primary key)
Continent - text
[tblCountry]
idcountry - text (primary key)
country -text
eu (europeaunion) - boolean field
[tblCustomer]
idcustomer - counter (primary key)
customer - text
address1 - text
address2 - text
address3 - text
address4 - text
fao - text
[tblPacking]
IdPacking - counter (primary key)
Packing - text
[tblCourrier]
IdCourrier - Counter (primary key)
Courrier - - text
Main Table
[tblDataEntry]
ProformaInvoiceN° - Text (Counter and Primary Key)
ShippingDate - Date/hour
OurCode - Text
Reference - Text
Courrier - Text
AirWayBill - Text
N°Packing - Text
Packing - Text
GrossWeight - Text
NetWeight - Text
Dimension - Text
Cost - Text
Sample1 - Text
CustomTariffN°1 - Text
Sample2 - Text
CustomTariffN°2 - Text
Sample3 - Text
CustomTariffN°3 - Text
Sample4 - Text
CustomTariffN°4 - Text
Sample5 - Text
CustomTariffN°5 - Text
Continent - Text
Country - Text
EU (EuropeanUnion) - Text
Customer - Text
Address1 - Text
Address2 - Text
Address3 - Text
Address4 - Text
Fao - Text
Hope this can be usefull for you.
Thank in advance and kind regards,
Marc
|