Help with tables, importing PDF and relationships.

[Syberpanther]

Sorry if this is a double post.

I saw a post in here before when I searched for "multiple tables" but it was
only part of what I need answered so I'm starting a new one.

I have a "Distributers" and a "Products" table. The Products table has a sub
table linked in because one of the products has a few slight variations that
are different enough to need their own table. It was suggested to create a
lookup field that holds the Distributer ID on the Products table. I've read a
bit about the lookup fields creating more issues. Maybe I need to do
something else? I think right now I have check boxes that should show up
under the Distributers for the selection of yes, has this product or no,
doesn't have product.

I guess I'm having an issue determining what needs to be built into the
tables and then what would be on the user end for adding more data to the
existing table after I have the structure built. Ultimately, I'll be handing
the database off once i've completed it. At this point, I don't actually need
any queries...I dont' think. Probably just a form to be able to add new
Distributers and maybe new products. Mostly, the group that is using it would
have a person that could update the finished project.

Another slight issue is with importing. They want a series of PDF files
accessible through the database. How would I link them in? Is it even
possible? I've done excel imports, but never PDF's.

Any help would be greatly appreciated.

 

[Pieter Wijnen]

In simple Terms NO!!!!
You'd want three (base tables)
Distributer
-------------
DistribiturID
DistributurNane
etc

Product
--------------
ProductID
ProductName
ProductBelong (self join refering to ProductID for deviant products)
etc

DistributorProduct
---------------
DistributorProductID (not neccessary per se, but I always use an *idiot* key
for all my tables
DistribiturID
ProductID
(etc)

It does make for some thinking (Productbelong), but usually pays off in the
long run
Post back for more
--
Pieter Wijnen

My feeble Access pages (good links though)
http://www.thuleeng.com/access
When all else fail try:
http://www.mvps.org/access
http://www.granite.ab.ca/
http://allenbrowne.com/
http://www.lebans.com/