Jump to content

Steita

Members
  • Content Count

    1
  • Joined

  • Last visited

  1. 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.
×
×
  • Create New...