@isaacjaco49111 said in join a resource with a variable:
@Fox I understand, so for example if I have 20 accounts and I want to obtain resource 18, should I create 18 resources?
Create one resource and put the data of 20 accounts in it
Select Database Table as Resource
-
I have a database with 2 tables, each with various columns.
How can i load / parse and use data from the 2nd table? What i did so far (with just one table) was to create a new resource (database type), parse from that resource and i had all the variables to use.
But with 2 tables, i don't know how to select just the 2nd table to use as database resource or make it parse just the 2nd table...
-
Double click or Right click --> Edit
-
much appreciated
-
Hope that really answered your problem. Can also use the "Select Records" command, change the Table to the second one and add any filters you need. This will return all records in a list and using the Foreach will get the job done.
Allister ☯
