Repeating records? I think that I am not explaining myself well.
Supplier table
Supplier_code | Supplier_description | Address
1 | king products | chicago IL
2 | grey Products | detroit Mi
3 | blue Products | seattle Wa
4 | red MFG | Los Angeles CA
5 |...
My tables are normalized.
Each item has 1 factory.
Item_table
Item#| Item Description| Item collection | Item supplier
Item_Supplier_table(It is fixed at 5 potential suppliers for strategic reasons)
Item_supplier | supplier_description | ....
I am trying to use a button to allow us to run...
Can someone point me in the direction of a tutorial to do the following
I have a continuous form that allows me to choose the supplier for a product
product name | supplier 1 | supplier 2 | supplier 3 | supplier 4 | supplier 5 |
text box button button...