Populating Fields

ghilton

being a newbie to Aware development I was wondering is this is possible.

I have a table called Product and one called StockCheck

What I would like to do on the form of stock is select a product from the product table (have done this ok) butI want to populate the quantity field on the stock check form automatically from the product table quantity field depending on the product I select.

Not sure if that was to clear?

Example

Product table:
prodname - item 1
Quantity - 4

Stockcheck form:
Select prodname to = "item 1" (Drop down box linked to to Product table)
then the quanty field will pull in the value 4 from the product table automatically.

Thanks in advance 😮

ghilton

hey I even answered my own question how is that for being good? 😃

This is now sorted. I am now off to sum a couple of fields on one form to update the value in another table!!!!! No rest for the wicked!

Happy New year to you all