Help! Help! Help!

[Guest]

I know someone knows this answer. How can I use one table that contains
company name and addresses on multi fields in another table. An example is
that one table has two fields for manufacturer and supplier. The same company
may have both roles. so thats why i need to pull this information again. not
just once.

Your help is most appreciated.

 

[John Vinson]

I know someone knows this answer. How can I use one table that contains
company name and addresses on multi fields in another table. An example is
that one table has two fields for manufacturer and supplier. The same company
may have both roles. so thats why i need to pull this information again. not
just once.

Your help is most appreciated.

Please post the relevant fieldnames and relationships. You can see
your database. We cannot. There's insufficient information here to
even guess how to construct the query.

John W. Vinson[MVP]

 

[PC Datasheet]

You could use a table structure like this ---
TblCompany
CompanyID
CompanyName
etc

TblManufacturerSupplier
ManufacturerSupplierID
ManufacturerSupplier 'Text "Manufacturer" or "Supplier"
TblProduct
ProductID
ProductName
etc

TblProductManufacturerSupplier
ProductManufacturerSupplierID
ProductID
CompanyID
ManufacturerSupplierID

The same company (CompanyID) could be both the manufacturer and supplier for
any product. You would have two records of the same CompanyID for the
ProductID. ManufacturerSupplierID would be different in each record.

 

[StopThisAdvertising]

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1100 users have come to me from the newsgroups requesting help
(e-mail address removed)

--
To Steve:
Over 300 users from the newsgroups have visited the website to read what kind of a 'resource' you are...

To the original poster:

Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html (updated)

Arno R