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
Thank you very much for this. It was really helpful. It did a majority of the work, and there are only a few formulas that I am not getting right, but will continue to dissect them.
There is a great sample of a Dataverse app that does everything you are asking and more. It may take some effort but in my own experience it was really worth it. If you run through the exercise you will learn how to set up your tables. https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/northwind-install