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

It's hard to tell from your post, and from the database, jsut what you're trying to do.

It kind of sounds like your table schema could be better and more descriptive.

maybe someone else can help ?