Hi Everyone,
I have a listbox with multiple columns
Columns 0 & 1 display username & group
Example – Bloggs Joe – Group A. - retrieved from tbl_T_Trainee
I have a table tbl_C_Groups which stores which Subjects the user has covered on a weekly basis.
Example.
Week1 Maths
Week2 Maths
Week3 Maths
Week4 Geography
Week5 French
Week6 Geography
Is it possible to populate the listbox with the subject covered using the table data?
I only want each subject to appear once, and if possible use only the first two letters of the subject.
Example
Bloggs Joe-Group A-Ma-Ge-Fr
Sounds complicated to me but I hope it is possible.
Many Thanks
Mark.