F
Fly Boy 5
I need to design a filler order database.
Tables = Customer, Filler Order, Filler Options
Fields in Customer = Customer no., Sequence no., Company name, address,
city, state, zip, phone no., fax, Three contact and titles
Fields in Filler Order = Date orderd, filler model, filler serial no.
Some of the Fields in Filler Options = Meter type, loading, fitments,
container1, container2, cip type, pump type, ect.
I would like to filter out certain options for certain filler models
Any suggestions on linking the tables together would be appreciated.
Tables = Customer, Filler Order, Filler Options
Fields in Customer = Customer no., Sequence no., Company name, address,
city, state, zip, phone no., fax, Three contact and titles
Fields in Filler Order = Date orderd, filler model, filler serial no.
Some of the Fields in Filler Options = Meter type, loading, fitments,
container1, container2, cip type, pump type, ect.
I would like to filter out certain options for certain filler models
Any suggestions on linking the tables together would be appreciated.