Ongoing payables

[Bikeman17]

Hi there. I have two tables. One for accounts payable and a second one for monthly ongoing payables. The last one holds 10 records which are recurring expenses. I am struggling to transfer the recurring expenses to the accounts payable table. What would be the best approach to deal with this issue?

[siroos12]

You could import them into "accounts payable" table and use "replace field content" or loop through imported records and set their Foreign-keys if needed. 

Or, you can make a relationship between the 2 tables and allow "recurring expenses" table to create records in "accounts payable" table. Then loop through records of "recurring expenses" table and create records in "accounts payable" table using a portal. 

You can set the fields values in the loop script using "set field" script step, or you may use "lookup" or "auto enter calc" on "accounts payable" table fields to pull values from "recurring expenses" table.