Hello. I am trying to pull data from a table, using data from another table to populate a text box/table record. How can I do this?
Great idea. You can do this by loading table records one by one based on text fields in the original table record.
Let’s imagine that you have a Table with work orders. Each work order has 5 products, each one with a unique ID. So that means that there are 5 text fields in the Table.
First, you must create a record placeholder for the record in the “Work Orders” table. Then, create a record placeholder for each of the 5 individual part numbers. So, you should have 6 total record placeholders.
Then, load a record from the “Work Orders” Table into the app. After that, you can load individual records from a second table like this: