Hello
I hope someone can help with this. I am really new to this, so I would appreciate any help.
I have created a number of tables in the common datasource area of powerapps 'dataverse'. It is for an ordering system. I have a customer table, I have an order table, product table and a table that, for lack of a better name, is called invoice-product table. I have them all working separately but am trying to clean them up for a newform.
At the moment I can go onto the Order page and select the customer, which creates an invoice id. Then I can go onto a form linked to the invoice product table. On this form I can select the invoice id, the product ids, and add a quantity.
Ideally I would like to be able to automate the invoice id when going from the Order page to the invoice-product page.
I am still trying to work out how to get the 'Customer Name' showing (as it is an id link). But more importantly I would like to make it so that the OrderInvoiceID automatically selected the invoice number above, so that multiple product orders can occur and be assigned to that invoice. But they are from two different datasources and are links/ids. (I am also going to try and amalgamate some of the buttons, once I have streamlined the form inputs). All my one to many relationships are connected and working.
Thanks
