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/
"Syberpanther" <(E-Mail Removed)> wrote in message
news:4756196A-73CA-4A45-8051-(E-Mail Removed)...
> 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.
--------------------------------------------------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4868 spam emails to date.
Paying users do not have this message in their emails.
Try SPAMfighter for free now!
Similar Threads
