this is probally a basic question, I have serveral tables which have a one row to one row relationship my problem is with the one row to many rows
one table with operation times - all times in a separate column in one table with the operation number to join it with other tables one of which is a table containing codes for what operations the patient has had during this theatre spell.
Another table contains the staff present during the theatre spell a row for each member of staff
I want to produce a report which produces 1 row in a report showing times operation1 ... operation99 staff1 ... staff99
opno in ana in th out th op1 op2 op3 med1 med2 nur1 nur2
123 10:00 10:10 10.45 AS3 DE6 DE4 S12 S34 N14 N50