AnsweredAssumed Answered

trying to have one created record affect another in a different database

Question asked by mpeay on Dec 4, 2018
Latest reply on Dec 4, 2018 by philmodjunk

I have two separate databases: #1 "SEOC" & #2 "ICR Generator". #1 has a layout called "case number generator (#1a).  I have set relationships for #1a and #2 via their fields "case number" and "date" in both databases (image attached).  I need new records created in #1a to create new records in #2 with the same case number and date. This must be a one way set up so that users of #2 cannot create/change case numbers or dates.  I have tried a script from another post (image attached) but it only makes new records in #1a.  Any solution must be accomplished without 3rd party programs such as SQL.  Thanks in advance.