My project has a requirement to produce a document listing all products in a specific location in order for the employees to count and enter quantities.
I have tried using a Master-Detail application to have the user select the location in the master and the detail form (multiple records) would list all of the products in that location with a description and a blank field to enter the counted quantities. I am using the location Id as the foreign key, but am still getting the records for all locations without filtering on the selected location.
Is there a better way to create such a document? This would be used by the back office to enter the new quantities and update the inventory table.