General

Re: Tables are joined wrong, need to change them maybe(?)

trufooser — Thu, 15 May 2008 18:22:46 GMT

But wouldn't that prevent me from entering data into the Episode by causing a many to one relationship?

Re: Tables are joined wrong, need to change them maybe(?)

Clay Fox — Wed, 14 May 2008 04:44:34 GMT

I think you would want to structure your data by Visit data primary and then with a key field to the patient and episode.

That way you could query by visit date.

Tables are joined wrong, need to change them maybe(?)

trufooser — Wed, 14 May 2008 04:17:00 GMT

I have a list of patients that are seen at our clinic in an Access DB in a structure as follows.

demographics
      insurance
      episode
          visit
          dx
      financialInfo

The form in question is a master/detail, my first master/detail. The form should work by entering a date into the visitDate query field, and the form will return just the visits (and episode and demographic info) that occured on that date.

Right now, the form is doing a left join(???), returning all patients, regardless if that patient had a visit that day.

Thanks for any help