Another Multiple Entry

T

TJ

Here is another table with multiple entries

Brand Products

One Entry Multiple Entries/Single Entry (but no drop down
table)

Thanks.
 
R

Rick B

Specific would be...

Ford Escort
Explorer
F-150.


If I read your post correctly, you want a one-to-many relationship. Again,
we need more details to give you specific help. Quit typing ten-word posts.
SPELL IT OUT. Pretend we have no idea what you are doing, what industry you
are in, where you work, what your database deos, what type of data it holds,
what reports you will need to create, what types of calculations you will
perform, etc.


Rick B
 
T

TJ

Okay I will do my best.

I am creating a database system to withdraw information in handwritten forms
about importers quickly.

The original tables in the forms have suppliers, country of origin, brand
names, products being bought. We need to be able to draw information out of
the system based on all of these criteria. Problem being that country of
origin and suppliers will have a many to one relationship to the importer,
then the brand names will be many to one to the country/supplier, and finally
the brand names may be a one to many for products.

Another complication is that we know the importer gets certain products from
certain countries, but we may not know the supplier or brand names.

Queries will need to enable us to research which importers import from what
countries.

Which importers import which brands.

Which importers import which products.

Which importers import what products from what countries.

I hope this explains everything much better.

TJ
 
Top