Suppose that there are now two tables: work units table, waybill table

Work units table including their own units, customer unit, the logistics unit, the supplier unit,

Unit in the table in the waybill, it is necessary to delivery, receiving unit, the logistics unit, the three different working unit,

When relationship set, although can work directly with the unit table's primary key, corresponding waybill three working unit to the foreign key in the table, but due to there are many other table, eventually forming relationship can appear very messy,

Excuse me: if I can in the work table and waybill between tables, query with delivery unit, receiving unit, the query, query to docking logistics unit?
If I can, so what are the items need to be aware of?
If not, then what is the better way?

Note: due to special reasons, not to consider a separate table set shipping unit, receiving unit table, logistics units table method,

CodePudding user response:

Like this, in the waybill information should be stored directly in the table units

CodePudding user response:

Because the capacity of the Access is limited, so I hope that the data in the table can save a province, finally purposes, there are many ways of use VBA to manipulate the data, for example, can don't even need to establish a relationship, I just want to have a better,