minimum quantity.

[eran3185]

hi
i try to build an access form .
i have "big" table that fill in the name of the product , the quantity , and a minimum quantity.
the field : min quantity give us the quantity that is the minimum of the product.
i have a "minimum" table that has the list of the product and the minimum quantity.

i want to see the minimum quantity of a product , when i type the product (in the form if it possiable , if not - in a report)

eran

[geekgirlau]

A couple of points:

First of all, I'd rethink a couple of field names. In the table "big", I'm assuming that the field "Number" is a unique identifier for the product. IMO a better field name would be "ProductID".
The table "minimum" should contain the ProductID, not the descriptive text for the product.
Your relationships are incorrect. "Big" is related to "Minimum" via the ProductID field.
The field "quantity - min" does not need to appear in the "big" table - you can capture this via a query.I've attached a sample, along with a query to show you how to capture the data.

[eran3185]

it help me
:hi: