Question on Access 2000 Design Many-to-Many Relationship ?

[Guest]

Hello,

The first table on my project an I'm already stuck.
I need to build a table in access 2000 that contains some product information.
This table contains several fields which were then separated into 6 tables.
* TblItem (ID; ManufCode; DescriptionEN; Supplier; Cost; Imagelink)
* TblSupplierCode (ID; SupplierCode)
* TblSize (ID; Size)
* TblStorage (ID; Storage)
* TblShipping (ID; Shipping)
* TblUNNumber

In our industry there is only one manufacture for each product. This
manufacture issues one ManufacturePartNumber for each item.
However, I also need to relate this unique ManufacturePartNumber to several
different Reseller Part Numbers.
What would be the best approach for the tables ? I tried many-to-many
relationship in access but I might have something wrong. Also tried lookup
value as a table field in TblItem but can't seem to make it work.
I know this is a basic question but any help would be greatly appreciated.

(e-mail address removed)

 

[Amy Blankenship]

Hello,

The first table on my project an I'm already stuck.
I need to build a table in access 2000 that contains some product
information.
This table contains several fields which were then separated into 6
tables.
* TblItem (ID; ManufCode; DescriptionEN; Supplier; Cost; Imagelink)
* TblSupplierCode (ID; SupplierCode)
* TblSize (ID; Size)

Where is this being used?

* TblStorage (ID; Storage)

What is this for? It doesn't appear in any other table.

* TblShipping (ID; Shipping)

Same question.

* TblUNNumber

Huh?

So really I can help you with only the first 2 tables, since the other
tables don't seem to have a use.

In our industry there is only one manufacture for each product. This
manufacture issues one ManufacturePartNumber for each item.
However, I also need to relate this unique ManufacturePartNumber to
several
different Reseller Part Numbers.

That means you need a Reseller table...

ResellerID
ResellerName
ResllerStreet
etc.

And a ResellerParts

PartID
ResellerID
ResellerPartNum.

What would be the best approach for the tables ? I tried many-to-many
relationship in access but I might have something wrong. Also tried lookup
value as a table field in TblItem but can't seem to make it work.
I know this is a basic question but any help would be greatly appreciated.

Not sure what you're doing with this table, so that's as far as I can get
you.

HTH;

Amy