Hi List,
I have tried to get my head around this, but failed.
Simply, Consider three MS Access tables...
* DOCTORS - Fields: Doctor_ID, Doctor_Name
* LOCATIONS - Fields: Doctor_ID, Address (each doctor can have
more than one address)
* CLINICS - Fields: Doctor_ID, Clinic_Name (each doctor can work
at more than one clinic)
What I want to do is display...
Clinic Name 1
Doctor Name 1
- Address 1-1
- Address 1-2
Doctor Name 2
- Address 2-1
- Address 2-2
Clinic Name 2
Doctor Name 1 (same doc different clinic)
- Address 1-1
- Address 1-2
Doctor Name 3
- Address 3-1
- Address 3-2
- Address 3-3
...etc...
Any help/suggestions most welcome...
Thanks
Tom
________________________________
Tom MacKean
Copywriter/Designer
Phone: (02) 9229 6465
Fax: (02) 9231 6965
Mobile: 0414 312 803
NOTICE: Medical and scientific information provided in print and electronically by
Sydney IVF might not be relevant to your own circumstances and should always be
discussed with your own doctor before you act on it. This communication is
confidential and may contain copyright or otherwise protected information of Sydney
IVF Limited or a third party. If you are not the intended recipient of this
communication please immediately let us know by reply email or telephone us on +61 2
9221 5964, delete the communication and destroy all copies.
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
