Sorry, Clinics not the same as locations. i.e. A doctor might see patients at their rooms in both Burwood and Camperdown (locations) but perform all procedures at clinics at both City and Liverpool.
Tom -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Faulkner Sent: Thursday, 22 April 2004 12:02 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Multiple Tables (newbie question) Hi Tom, I may be wrong it looks like you may have your table definition slightly awry here.. Your doctor to clinic relationship is many to many ( all clinics have many doctors, all doctors visit many clinics ), but doesn't one clinic only have one location, or am I misunderstranding your structure? Or is the LOCATION not of the CLINIC but of some other object? ----- Original Message ----- From: "Tom MacKean" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, April 22, 2004 11:53 AM Subject: [cfaussie] Multiple Tables (newbie question) 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 --- 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 --- 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
