Gossamer Forum
Home : Products : DBMan : Customization :

Append to 2nd DB using info from add form

Quote Reply
Append to 2nd DB using info from add form
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?
Subject Author Views Date
Thread Append to 2nd DB using info from add form Helpdesk 2362 Jun 29, 2002, 10:54 PM
Thread Append to 2nd DB using info from add form [update]
Helpdesk 2254 Jul 4, 2002, 12:56 PM
Thread Re: [Helpdesk] Append to 2nd DB using info from add form [update]
LoisC 2261 Jul 4, 2002, 1:06 PM
Thread Re: [LoisC] Append to 2nd DB using info from add form [update]
Helpdesk 2250 Jul 4, 2002, 1:15 PM
Thread Re: [Helpdesk] Append to 2nd DB using info from add form [update]
LoisC 2258 Jul 4, 2002, 7:08 PM
Thread Re: [LoisC] Append to 2nd DB using info from add form [update]
Helpdesk 2257 Jul 4, 2002, 7:45 PM
Thread Re: Append to 2nd DB using info from add form [update]
Helpdesk 2233 Jul 8, 2002, 7:47 AM
Post Append to 2nd DB using info from add form [update]
Helpdesk 2210 Jul 22, 2002, 6:10 PM