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
LinkedIn
Twitter
