how would i select 1 record from one table (or database) , show it in a layout on a different table or db
my set up is:
1 job ticket db
1 stock db
i want to select 1 record from "stock" and enter it in a layout on the job ticket db with upto 6 different stocks being shown in real time in that layout.
i already have both db's running with records in each.
the highlighted part in the image is where i need to post the records from "stock"