Hello,
I'd like to create a form for registration of inventory checking. The way I'd like to do it as follows:
- I have form with some form fields and with a subform (subform is a blank form)
- If I choose the warehouse (form field) I want to check (the company has several warehouses, so I will need an "if condition" in the script), I'd like to see the subform to be auto populated with all the products and their current inventory values, which can be found in that warehouse
I could find some topics in the forum on how to manage subform rows dynamically, still struggling :( with undefined number of rows and combining it with auto population...)
Inventory values are stored in the product form.
So I would need your support in a script "on user input".
Form name: Inventory_check
Subform name: Check_invetentory_details
Subform fields I'd like to manage dynamically and with auto population are:
Product (lookup) >>>> Product form, Product field
Inventory >>>> Product form, warehouse1, warehouse2 etc
So, if I choose warehouse1, I'd like to see all the products with their current inventory value (which are not null), if I choose warehouse2, I'd like to see all the products in warehouse2 with their current inventory value(which are not null)..
I'm sure, some Gurus (Damien :)) will get the point.
Thanks, all of you have a nice weekend and stay safe!
George