Originally Posted by
neilsolaris
Hi Bob,
You're right, I didn't design the database properly when it came to instruments. What I did, was create a table (T_Instruments) with 3 columns. Columns 1 was the unique player number, then I entered the their instrument in column 2, and if they played another instrument I entered it in column 3. Now I've seen yours I know how I should have done it! As I've got 750 players (the vast majority of which only play one instrument), I wonder how the quickest way would be to reorganize the data.