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 ☯