Multiple Database Relationships

[mhemans]

I have two databases that I can easily relate to a third with a common field. This allows me to key in data in the third and have some of the data show in the other two databases, which keeps me from entering common data multiple times. However, I want to create a record in the third database and simultaneously create a record in the first or second database that includes a copy & paste of the common field, which happens to be a serial number. I can do this with a table, but prefer to keep DB 1 & 2 separate from 3 as DBB 1 & 2 are shared by different groups of people via Instant Web Publishing. How can I do this?

Edited August 8, 2009 by Guest

[SoCalMacDude]

You could create a script that sets a global variable for each field that you want to populate, then it triggers a script in the other database(s) that does a Set Field for each field using the $$Variable as the data.