Hello everyone, I have searched this extensively and have not found an answer to this issue. Here is what I am trying to do:
We have a 'Vendors' table and a 'Products' table that is joined by a many to many relationship through a 'VendorProducts' table as multiple vendors can have the same products and we need to record vendor specific properties for their products in the VendorProducts table.
In the Power App I am working on when creating a new vendor there is a tab on the edit form where we want to be able to add brand new products to the products table as well as VendorProducts objects to their table. I get that I can use the patch command to persist the Product first, then use the peristed product as a property on the new VendorProduct, but that is only half the info, I still need the VendorProduct to know which Vendor to relate to. Is there some way I can reference the unsaved Vendor when saving the VendorProduct?
What I am trying to avoid is a user having to create a vendor and save, then re edit the vendor in order to add products to it.
I hope this description is clear, and thank you in advance to anyone who has a look at this.
Aaron
