Scribe - update/insert record with intermediate table

[tony wright 2]

Hi, is there a turorial on how to setup scribe so I can do an update/insert on two tables that have an "Intermediate" table between them

I am using the CRM Dynamics connector and have added the tables but I don't know how to link the tables so a new record can be inserted in the 3rd table.

My souce connection has AccountId which connects to the first and second tables easily enough, how do I link to the third table

Obviously the addressid won't exist until the record is created in the intermediate table.

 

 

 

Account

 

Intermediate

 

Address

 

 

AccountId

--------->

AccountId

 

 

 

 

 

 

AddressId

--------->

AddressId

 

 

 

Thanks

Tony

[Audrey Buettner]

You can create a User Target Variable that will pull the AddressID from that specific Data Object/Step. Then map that variable to your Address field.

[tony wright 2]

Hi, thanks for the hint about using variables. I thought I had managed it when I found out about the cross reference linking, and it worked fine when inserting a new record. However when updating an account and adding a new address record of type "invoice", it seems to add the new record as type "Work" (default) and updates the current record (Which was "Work") type to "Invoice". I thought I might be able to add a Seek with the variable "XRefValue" created in the Cross Ref Linking but it just shows "#NULL!" when I try to use the variable  (Even though the cross linking works)

 

Are there any examples of using the variable in a solution

 

Thanks

 

Tony

[Audrey Buettner]

Adding a pic that hopefully helps...