Transfer Products

[mis]

Hi Forum,

I created a table so that it would transfer products from one store to another, the table structure is as follows:

TransferID AutoNumber
StoreID Text
ProductID Text
Quantity Number

One problem is that the table only allows one product on one transfer ID i would like it to allow as many as the users wants any idears.

 

[Mile-O]

Why are the ID fields Text and not Numeric?

 

[namliam]

You have a 1-1 to do what you want is needing a 1-many

1 table:
TransferID AutoNumber
FromStoreID Text
ToStoreID text (probably)
someDate date (maybe)

2 table
TransferID AutoNumber
ProductID Text
Quantity Number

KeyValues

Hope that helps you along....

Regards

 

[mis]

Clearing Up

Can you clear it up for me, you make sure that the id matches up so that you can add several products. How would achieve this in a form, the user would need to add in as many products as they like and complete and print the finnished transfer list.
???

 

[namliam]

find a 1 to many example, i am sure there are many on the board....

 

[neileg]

Create a main form for the first table in namliam's suggestion. Create a subform in continuous form mode for the second table and drag this onto your main from. The Access subform wizard should syncronise the ID fields so that the subform shows the detail that matches the data in the main form.