On the Job Receipt to Inventory, I wanted to put a simple grid at bottom.
When the job number field on the form is updated, this grid fills with the query:
select trandate, trantype, tranqty, warehousecode, binnum, entryperson from parttran where trantype = 'MFG-STK' and jobnum = whatever the job number field has in it.
Is something like this simple enough?
In normal programming, I'd use the OnChange event of that jobnum text box to reset the rowsource of the datagrid, then requery the grid.
or do I do this a completely different way?
thanks for any help,
Tony
[Non-text portions of this message have been removed]
When the job number field on the form is updated, this grid fills with the query:
select trandate, trantype, tranqty, warehousecode, binnum, entryperson from parttran where trantype = 'MFG-STK' and jobnum = whatever the job number field has in it.
Is something like this simple enough?
In normal programming, I'd use the OnChange event of that jobnum text box to reset the rowsource of the datagrid, then requery the grid.
or do I do this a completely different way?
thanks for any help,
Tony
[Non-text portions of this message have been removed]