Spirodoc Posted November 28, 2008 Share Posted November 28, 2008 I have a database that shows a portal on an encounter that lists all the medications a person is taking. It is linked through a join table to the visit table and the visit table is set by the date seen. Is there a way to show the portal and data associated with it of a previous date for the same person on the date of their current visit. When I create new file for a new date then the join information is no longer visible. Most often patient medicines remain the same so seeing the previous list will allow me to know what they're taking and also set up a simple Portal Dupe to transfer last visits med list to the new visit. Link to comment Share on other sites More sharing options...
aldipalo Posted November 28, 2008 Share Posted November 28, 2008 See attached. hth Patient_Visits.zip Link to comment Share on other sites More sharing options...
Spirodoc Posted November 28, 2008 Author Share Posted November 28, 2008 Aldipalo, Thanks for the information. My structure is a bit different. I have a patient layout, a visit layout, a medjoin layout, and a layout that lists probably a 1000+ medications. Patients can be on more than one medication and the patient can have more than one visit so this reduces the many to many relationship. Medicines are selected as a pull through and from a drop down list. So my medjoin table only contains the kf_Med# and the kf_Visit#. One date of service is equal to the Visit#. I can't get the previous dates medication portal to display on my current day layout, even with the self join relationship as you suggested. Link to comment Share on other sites More sharing options...
aldipalo Posted November 28, 2008 Share Posted November 28, 2008 Either post a clone of your file or a jpg of your TOG so we can see it. The example I gave you is just so you could see the basics, I didn't intend it to be the final answer. hth Link to comment Share on other sites More sharing options...
Spirodoc Posted November 29, 2008 Author Share Posted November 29, 2008 Aldipalo, Hi I have enclosed my Clone for your review and thoughts! Thanks for your help!!!! _Clone.fp7.zip Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5767 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now