2 x DataTables and Datagrid
PLEASE HELP!
I am trying to populate a DBGrid wich will allow me to assign some tests to given sample numbers.
----------------------------------------------
SAMPLE1 SAMPLE2 SAMPLE3 SAMPLE4 SAMPLE5
TEST1 x x x
TEST2 x x x
TEST3 x
TEST4 x
TEST5 x x x
----------------------------------------------
Once the test have been selected to the given samples this will then update a test assigned table. The first column is from tblTestNames and the samples then need to be added from the tblSampleDetails.
I can populate the two tables with the information but I can't seem to find any help how to merge the two sets of data and then send back to tblTestAssigned.
I hope this makes sence.
|