Form fills in table based on other related table

[jjitss]

I'm trying to find an answer on the folowing problem. I have 3 tables in Access:



Product
productID - category - productName - paceList - price
1 - x - product1 - 10 - 10.75
2 - x - product1 - 15 - 11.75
3 - x - product2 - 10 - 15.75
4 - y - product10 - 10 - 14.75

Order
orderID - customerID - orderDate - status

Orderdetails
orderdetailID - productID - number

__________________________________________________ __________

I like to have the folowing resulting form:

ORDERFORM:
Order 16242
Customer 1

Orderdetails subform: Number - category - productName - paceList - totalPrice
2 - x - Product1 - 15 - 21.50

__________________________________________________ __________

Users first have to fill in the category, than next only the products in the specified category become visible to fill in, and next all paceList amounts.

Important is, that the product table shouldn't be updated, only reviewed to add, change or delete new orderdetailrows

How can I do so?

[burrina]

Is your form bound? Are you saying you want the form to be read only?

Me.AllowEdits = False

[jjitss]

Thanks for your time Burrina. I figured it out by another workaround.

Now I'm opening an additional form in which I can select the product based on the three aspects, and when closing through a button the right product is selected.

But thanks a lot.

[burrina]

Your Welcome. Good Luck With Your Project.