I have looked at all the posts on appending to a field in a database with information from the add record form, but, none have to do with multiple databases.
I have database A which has records with ID as field 0 and another field called Work. And database B which has a separate ID field as field 0, and a field called Ticket, separate db file, separate pl file, and different field names.
What I want to do is when a a user enters a record via the add form in database B, they enter into the form the Ticket number which corresponds to the ID field in database A. And, when the record in database B is entered with this information I want it to append " $rec{'ID'}" (including the space) to the field Work in database A, append to the end of the field and not overwrite it.
I know this is possible, but I can't figure out how to do it. Can someone help me with this?
I have database A which has records with ID as field 0 and another field called Work. And database B which has a separate ID field as field 0, and a field called Ticket, separate db file, separate pl file, and different field names.
What I want to do is when a a user enters a record via the add form in database B, they enter into the form the Ticket number which corresponds to the ID field in database A. And, when the record in database B is entered with this information I want it to append " $rec{'ID'}" (including the space) to the field Work in database A, append to the end of the field and not overwrite it.
I know this is possible, but I can't figure out how to do it. Can someone help me with this?
Append to 2nd DB using info from add form