minimum quantity

[eran185]

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

 

[Bilbo_Baggins_Esq]

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.

 

[eran185]

maybe someone else can help ?