List of records from one line multi data field

[Steita]

Hi to everybody.

I have a problem. I need a table, and relative DataPage insert data than can insert data of more than one customer.

In just one data Page i need to accept customer1 and customer2 data (name, surname, address, email, phone ecc)

Now the problem is that i need to have the 2 customers, NOT in a table with unic horizontal line, but listed, with new id but with the same booking number, for a new record in the table.

I think i need a new table but i can't be able to make triggers to copy data in a new table and records automatically (if that is the right way). 

 

(Ex. of the table/dataPage i have)  ID_ booking  | booking_number  | n_of_ customer |  Customer1_name  | customer1_surname | customer2_name | customer2_surname|

                                                                                  1                             56789                               2                                      John                                     Doe                                     Mary                                 Harris

                                                                                  2                             56790                               1                                    Micheal                                Lewis

                                                                                 3                              56791                               2                                      David                                    Clarke                                Rose                                   Smith

 

(ex. of what i need)                                        1                            56789                               2                                       John                                     Doe

                                                                                 2                             56789                                                                        Mary                                    Harris

                                                                                 3                             56790                               1                                     Micheal                                Lewis

                                                                                 4                             56791                               2                                      David                                   Clarke          

                                                                                 5                             56791                                                                        Rose                                      Smith          

 

How can i do? 

Thank you for your time in advance.

 

[douvega]

Hi,

It seems this is a one to many relationship case.

You should have two tables, Bookings and Customers.

From the tables perspective, you must create the booking first and the associate as many customers as you may need to one specific booking (please let me know if this is the intended behavior).

So, you can use a submission form to create the new booking and then redirect the user to a tabular page that handles the booking customers but pass the newly created booking ID as a parameter.

Check this article about how to deal with parameters https://howto.caspio.com/parameters/

In the tabular form based in the customers table, you use the Add records in top option in the page results section.

This should have a hidden field that would receive the booking ID. This way you can associate as many customers as you need to the booking.

Hope it helps.