Create Link Table

[peter.pallen]

Hello All,

I was wondering how I could automate the following.
I currently have a database for tracking empty packaging.
In this database I have a form in which I create a supplier and then link
this supplier to the needed packagings and then also the the plants that
he is delivering to and the warehouse from where he can collect the
empties.
Now when I define the links on the Supplier side I also need to do the
same for the plants and the warehouses.

The supplier table contains the data for the Suppliers, Plants and
warehouses. The difference between supplier, plant and warehouse is made
based on a definition field that is filled with 1, 2, 3.

Now my question is when I have created the links for the supplier how can
I automatically create the links for the plants and the suppliers?

Regards,
Peter

 

[Tom van Stiphout]

On Thu, 07 Aug 2008 12:19:48 -0700, (e-mail address removed) wrote:

This sounds like bad database design. If I understand you correctly
you have:
tblSuppliersAndPlantsAndWarehouses
ID
Name
Definition

tblPackagings
SupplierID
PlantID
WarehouseID

Can you confirm? Then we'll talk more.

--Tom.
Microsoft Access MVP

 

[peter.pallen]

Hi,

No I have it setup as follows.

tblSupplier

SupplID
Name
Addr
City
SupplType

tblPackaging

PakcID
Partnr
Descript
PoolQty

For the packaging I have a link table

tblLinkPartSuppl

PartID
SupplID

tblLinkSupplPlantPlatf

SupplID
RecID
Active
SupplType
RecType