making transactions with multiple products (Diagram inside)

[sgtblitz]

Hey people, hows it going? Quick question

I am creating an EPOS system for a bookstore and I have a many to many relationship between the transactions table (tbl_transactions) and the products table (tbl_products) using a link table (tbl_linktblproductstransac). The below diagram shows what i mean below:

http://img512.imageshack.us/img512/3246/relationnshipswd9.jpg

I made it many to many because 1 transaction can have many products on it and 1 product can be on many transactions.

Now what I need to know is how will i make records with more than one product on one transaction (in the table itself or in a transaction form). I would really appreciate if someone could help. Thanks and have a good Easter

 

[sgtblitz]

Also, could someone please let me know how I would make the "No in stock" field decrease by 1 everytime a product is ordered.

Thanks

 

[durexlw]

Now what I need to know is how will i make records with more than one product on one transaction (in the table itself or in a transaction form). I would really appreciate if someone could help. Thanks and have a good Easter

This basically handles itself...
What you can do is open the tbl_linktblpr table in table design, Select the product No. field, and change it's Data type to a Lookup Wizard. When you finished the wizard, just open your tbl_Transactions table, create a form and you'll see a subform to link products to a transaction.

Make a new transaction on that page and you'll be able to add products to a transaction.