0
Regarding the issue of matching records after splitting the data.
![](https://s3-us-west-2.amazonaws.com/media.forumbee.com/i/dcf31b35-a9f2-4426-864c-f0ee5668332f/h/547.png)
- I have created three tables: "product," "invoice," and "Create." In the "Create" table, I have set up a button. I want to quickly create orders by clicking the button.
- For example, after clicking the button, it will create "cnt(select 'Create')" new invoice records, and in each "invoice" record, it will match the product record with the "product.id" corresponding to the number in "product nb." How can I achieve this functionality? Thank you for your response!
Some try.
let aa := this;
for i in select 'Create' do
for xx from 0 to cnt(i) do
let ywy := (select 'product')[i.'product nb' = 'Id'];
let newdd := (create invoice);
newdd.(
.....
4 replies
-
1) How does the number of records in Create affect the number to create of Invoices? What if you have 5 records in Create then want to create 3 Invoices then want to create 10 Invoices? Do you have to delete 2 records then create 7 records ?
It seems like you should have a number field "How many invoices do you need?" then use that.
2) I would suggest using a dynamic multi choice field to Products, so you already have the correct record Id to use to make the links.
3) are you making an invoice for each individual product or do you have a Line Item child table that you also need to populate?
Content aside
- Status Answered
- 1 mth agoLast active
- 4Replies
- 43Views
-
2
Following