1
Hello!
I am inserting a record into a MySQL table called ticketdata that has one unique id field - TicketID (int auto increment)
After I insert it, I would like to automaticly insert another record into a different table called updatedata. This table has its own unique id field - UpdateID (int auto increment) but also has a field ParentTicketID to link it to Ticket record.
How can I insert a new Ticket record, and then immediatly insert an Update record, when I do not know the ParentTicketID?
Any help would be appreciated!
JMass