The simplest method I can think of is using a hidden pop-over which contains a portal used for picking the product that will appear on your PO lines.
You would need to create a Cartesian join from your purchase orders to your product table to be able to display all products for your viewing. To be able to add new items into your PO lines you will need to open the hidden pop-over which has a search feature to find whatever you need. Then you select a product and it will be added to your PO lines portal.
I've created a rustic example which you can use to understand how you can do it. There are many other methods which will be more polished than this.
Hope this helps a little bit, feel free to ask any questions about it
Portal picker.fmp12.zip 115.9 K
Thank you VERY much! Will study.
Your RUSTIC attempt is a lot better than anything I can do right now :-)
Very very nice and I'll learn a lot from it. Thank you.
One question: in your example there's no way to add a new product but only to select them from a list.
How would you go about it? Just going to the Products and add it there and then come back?
What worries me is that I have a Products table that describes the good, then I have a Deliverables table that lists price and ordering codes for a given Product as distributed by a given Supplier so filling in an order line for a product that is not found means populating the Products and then the Deliverables tables ...
Thanks for any further advice
1 of 1 people found this helpful
On the pop-over you could just simply create a button - "New Product".
This would either take you to the products layout OR you could open up a new window to create the new product then you can fill in the appropriate details.