View Single Post
  #5  
Old October 17th, 2004, 07:59 PM
Marc
external usenet poster
 
Posts: n/a
Default

[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