Amanco

Hello, I need help please as I am new to the Anchor-Buoy using the following concept: I have a base table [PATIENTS] and would like to connect it to [STATUS], [DOCTORS], [TESTS], [TREATMENTS]...etc I looking to track the BOUYS Tables changes with time e.g. (A) Track the start/end dates/times of any [STATUS] changes of the patient --> becoming INPATIENT or OUTPATIENT or DISCHARGED (B) Track the start/end dates/times of [DOCTORS] interactions with [PATIENTS] ...etc 1) I figured a join-table is the approach to capture this data, is this correct? or is there

Hello, I need help please with the best relationship design. I'm designing a database for patients and their encounters/visits, and I would like to like to view their information related to each visit (Current and old). I have the following tables: tbl_Patient ---> tbl_Encounter (inc date/time) ---> many tables capturing patient data What is the best way to view the old patient data based on the past date and time? Thank you

Hello, Is it possible to make a slider bar field control like the attached image in filemaker 18? I only found a request feature 5 years back https://community.claris.com/en/s/idea/0870H000000fy9IQAQ/detail Thanks,

Thank you Steve, I have done what you suggested with a table separate for admissions with a date of admission and date of discharge. I attach my relationships. Okay, instead of the patient's name, I am going to use their unique chart number or National ID number to search for the patient and then add as new admission. Exactly as you suggested, I would like everything in their past history to be duplicated but under a new admission, so when I edit the information, It will not affect the information in their old admission encounter. Any pointers please on how to script this?

Hello, I am new to filemaker and using filemaker advanced pro 18. Im building a database for my patients who are admitted to the hospital. I would like help please with the following: 1) when I discharge the patient, the patient’s data are “archived” and not shown on the report. However, when the patient gets readmitted to the hospital, I would like to: 1) add patient by the hospital chart number 2) if patient is in the archive list, then activate and use the old data but under a new encounter to the hospital. whats the best w