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.