I have an accommodations/ticket order database. I would like to setup a rebooking system where a person could rebook in advance their accommodation/ticket package for the next year. I duplicated the database and named it REBOOK. The problem I am having is that if there is a change in their order in REBOOK and want to update information in the order form, it does not update when I import the changed info.  Any thoughts Basically what I want to do is add an updated order. There are two related tables - KB 16 & ticketOrd.   (See attached)

T

Why create a duplicate database? A re-book is simply another booking, with the same characteristics as the original except a different date, surely??

Yes, what webko said. In addition, why would you change an old order when you rebook?