Form design

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello.
I want to create a form that lists the items contained on several
warehouses. One type of item can be on several warehouses.
What i'd like to do is to have a form that on the first row displays all the
warehouses contained on the table. This number of warehouses are not fixed.
On the rows bellow appears the remaining information of the table. This
information should be in continuous form mode.

Is this possible?
 
You will need at least these 3 tables:
Product table (one record for each type of item):
ProductID primary key
ProductName ...

Warehouse table (one record for each warehouse):
WarehouseID primary key
Address ...

WarehouseProduct (one record for each product at each warehouse):
ProductID foreign key to Product.ProductID
WarehouseID foreign key to Warehouse.WarehouseID
Quantity quantity of this product at this warehouse.

The interface will then consist of:
- a main form bound to the Warehouse table.
- A subform bound to the WarehouseProduct table.
The subform will contain a combo box where you can enter the products at the
warehouse, one per row. The RowSource for the combo box will be the Product
table.

Technically, the WarehouseProduct table is known as a junction table. This
is the standard technique to resolve a many-to-many relation into a pair of
one-to-many relations.
 
Back
Top