Autopopulate form

[rythem]

1. how do i auto populate a form from another table. like a repair form pulling up information from the vendor table.

2. I have been trying to pull information into my form 'check stock' from a table called 'inventory'.
i want to be able to just enter the serial number and then autopopulate the rest of the data from the inventory table.

the quantity that is displayed in the check stock table must be the difference of the quantity in the inventory table and the requisition table.

3. Also, every time i enter something in the inventory table, i want it to be able to iteratively check for any avaliable stock and update the quantity instead of making a new entry every time.


please help

 

[maxmangion]

how do i auto populate a form from another table.

Check the database samples section of this forum, there is a good sample Pat Hartman, on how to autopopulate.

Also, every time i enter something in the inventory table, i want it to be able to iteratively check for any avaliable stock and update the quantity instead of making a new entry every time.

Do not do this at table level, as it is not recommended to store calculated fields in a table ... use queries instead.