Hi everyone.
In my database its normal to scan a serial number for an item and see where it was last used (Movement, Shipment, etc)
Currently I have a form with a textbox to enter the serial and then a query displaying the related movement from the movement table.
But I would like the user to be able to scan multiple serial numbers and produce the most recent movement for each serial scanned.
At the moment I have:
- Make Table Query (to supply me a blank local table to scan serial numbers into)
- I can have a Dlookup txt bringing a field from the Movement table Query
But I would like to display more related fields from the movement table, [Move ID], [Date], [Move reason], [Movement Type]
is there a method or producing this without having to have multiple txt fields with different Dlookups in them?
below is a very basic example, but its the serial and then the Dlookup field but i would like to pull more related info but in this kind of layout
For clarity in this screenshot above, those test serials all relate to the same movement so that is why the movement id's are the same in the second column)
then after they are done searching etc it will clear the table, or just have the make table happen each time they want to open the form
Any ideas? (thanks in advance everyone)
In my database its normal to scan a serial number for an item and see where it was last used (Movement, Shipment, etc)
Currently I have a form with a textbox to enter the serial and then a query displaying the related movement from the movement table.
But I would like the user to be able to scan multiple serial numbers and produce the most recent movement for each serial scanned.
At the moment I have:
- Make Table Query (to supply me a blank local table to scan serial numbers into)
- I can have a Dlookup txt bringing a field from the Movement table Query
But I would like to display more related fields from the movement table, [Move ID], [Date], [Move reason], [Movement Type]
is there a method or producing this without having to have multiple txt fields with different Dlookups in them?
below is a very basic example, but its the serial and then the Dlookup field but i would like to pull more related info but in this kind of layout
For clarity in this screenshot above, those test serials all relate to the same movement so that is why the movement id's are the same in the second column)
then after they are done searching etc it will clear the table, or just have the make table happen each time they want to open the form
Any ideas? (thanks in advance everyone)