use 2 tables on one form

Hi, i have a form with the source table set to ‘Job’ and on that form there is an global option variable with the options ‘job,Item’ and a tablebox with the fields ‘No,Name’ on it. Now if i change the global option variabel to item i want the table to show me the item records. any solution would be helpfull. thx, Wendy.

The solution could be like this: You use a buffer table and insert there records you want to display. So you set this table as source table for the form and just change contents of it.