SOLVED:Select numerical and random records then display together.
I have two tables called tblTable1 and tblTable2. They are not linked and they both have two fields called ID and Memo. The data type for the Memo fields are memo.
I would like to create a macro within the database that when activated will grab 1 record from tblTable1/Memo field in numerical order and 3 records from tblTable2/memo field in random order and then display them together in the same text box/form (whichever is possible/can fit the data), so that the record from tblTable1 is on top and the 3 records from tblTable2 are on the bottom. After, 40 seconds and/or the operator decides, I would like the macro to repeat the process but with new records from each table. If the program could continue until the operator ends it (perhaps by clicking a button) that would be ideal. Can you help me create the program that will bring this database to life?
I have two tables called tblTable1 and tblTable2. They are not linked and they both have two fields called ID and Memo. The data type for the Memo fields are memo.
I would like to create a macro within the database that when activated will grab 1 record from tblTable1/Memo field in numerical order and 3 records from tblTable2/memo field in random order and then display them together in the same text box/form (whichever is possible/can fit the data), so that the record from tblTable1 is on top and the 3 records from tblTable2 are on the bottom. After, 40 seconds and/or the operator decides, I would like the macro to repeat the process but with new records from each table. If the program could continue until the operator ends it (perhaps by clicking a button) that would be ideal. Can you help me create the program that will bring this database to life?
Last edited:
