integrate a Table view with data from a form view

[Ruxandra]

Hello!

I have a table 1, a template of set of rows (let's say 50 rows), laboratory tests, meaning, name of the test, price of the test, number of test made, e.g, test 1, price 1, number of tests empty field, it should be filled in by user; on the other hand, I have another table 2 to select the customer of these laboratory test and the order for  testing. The third table (Table 3) should integrate a copy of the selected rows from table 1 (user should be able to select 1 or more tests, from the 50 rows), and also the information about customer and order on every row. 

For Table 1 I created a Table View , for the second a Form View, how could I combine both view Table and Form; the idea is that user fill in the form with customer and order, then he should be able to select from the template the necessary rows, depending on what tests he has to do, fill in the number of tests, then , and when he saves the form, both the information about the customer and the order, as well as all the rows selected with tests must populate the Table 3, and information about customer and order should be written for every selected rows.

It combines one row with many rows.

Could you help me with some suggestions how should I do?

Many thanks! 

Regards!

Ruxandra

[Marc_Dillon]

You can select multiple rows from the 1st table with an EnumList-Ref column on the 2nd table.

Alternatively, you can build a "selection dashboard" that opens up after (or before) saving the table2 form, that allows the user to select multiple table1 records, via inline record-flagging actions. "Flagging" means to set some value to a column in the record such that you can lookup/refer-to the record from elsewhere. For example setting USEREMAIL() to a column, then you can get all flagged records with FILTER( table1 , [flag-column]=USEREMAIL() )

[Ruxandra]

Hello!

In the Table 3, I need to have all rows selected from 1Table (meaning also another 2 columns, prices and number of tests); if i use a EnumList, how could I transform all data from this List field in rows in Table 3?

The Useremail is the same, it is only one user who does this, for instant.

Thank you!

Regards!

Ruxandra