Our Preferred 5 Star Hosting Provider - Award Wining FileMaker Pro Hosting
Results 1 to 4 of 4
  1. #1
    FREE Member
    Join Date
    Oct 2012
    Posts
    5
    Downloads
    0
    Uploads
    0

    Help want to create a set of static data entry fields that populates a dynamic tabl

    Ok so here what i want to do

    i have a need to log relevant medical history for a single patient record (each single patient record has a unique identifier)

    some of these patients have multiple relevant medical histories/procedures that i need to record (an the number of relevant medical histories/procedures is variable for each patient obviously.

    what i would like is the ability to have a standard set of fields

    1. procedure
    2. start date
    3 continuing (yes/no)
    4. enddate
    5. comments

    when i type into these feilds they export to table for that patient

    1 pocedure start date continuing end date comments
    2 pocedure start date continuing end date comments
    3 pocedure start date continuing end date comments
    4 pocedure start date continuing end date comments

    I think that this needs to use a portal and a related table but i am stuffed if i can figure out how to do this beyond a concept

    any help much appreciated
    Warning: This is an Old Thread
    This discussion is older than 420 days. information contained in it may no longer be current

  2. #2
    Good guy doughemi's Avatar
    Join Date
    Apr 2005
    Posts
    948
    Location
    Middleport, NY USA
    FileMaker Version
    FM 9, FM 9 Server, FM 11, FM 11 Server, FM 12
    OS
    Windows & Mac
    Skill Level
    Intermediate
    Downloads
    0
    Uploads
    0

    Re: Help want to create a set of static data entry fields that populates a dynamic t

    Put your "standard set of fields" along with a patient ID field in a table (let's call it Procedures). Create a relationship Patients::PatientID =Procedures::Patient ID. On a layout based on your Patients table, create a portal to Procedures, sort it by start date, and populate it with your procedures fields.

    The Procedures records don't really export to the patients table, they are merely viewed there via the portal.
    Give the gift of life. Register as an organ donor today!
    http://www.organdonor.gov/become.asp

  3. #3
    FREE Member
    Join Date
    Oct 2012
    Posts
    5
    Downloads
    0
    Uploads
    0

    Re: Help want to create a set of static data entry fields that populates a dynamic t

    Thanks doughemi! I got it working using portals as you suggested. I have duplicated this for dug history and reaction/event history. See screenshot below.

    What i now need to do is work out someway of showing the running total of entries per patient by reporting the running total of each time the patients unique ID(case safety report ID) occurs in the related table. Something i am currently struggling with, as you can see from the screenshot that shows a report of "0"

  4. #4
    Good guy doughemi's Avatar
    Join Date
    Apr 2005
    Posts
    948
    Location
    Middleport, NY USA
    FileMaker Version
    FM 9, FM 9 Server, FM 11, FM 11 Server, FM 12
    OS
    Windows & Mac
    Skill Level
    Intermediate
    Downloads
    0
    Uploads
    0

    Re: Help want to create a set of static data entry fields that populates a dynamic t

    It's getting late, but you should be able to create a layout based on the join table. In it, create a summary field =Count(ProcedureID) (--You DID create a procedure ID field when you built your Procedures table, I hope!). Place it in a Sub-Summary part when sorted by PatientID, along with PatientID, and if you wish, Patients::name. Then sort the table by PatientID and you should see the totals per patient. If you just want to see the totals, you can delete the body part of the layout.

    As a Limited Access Member, you may not upload screenshots, so I cannot see what you are attempting to do. If my answer doesn't work for what you are after, please post again.
    Give the gift of life. Register as an organ donor today!
    http://www.organdonor.gov/become.asp

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 08-10-2013, 07:55 AM
  2. Drop down that populates additional fields
    By ervinleasing in forum FileMaker Pro Versions 5 & 6
    Replies: 1
    Last Post: 07-10-2009, 02:12 PM
  3. How to clear fields for new data entry
    By plux60 in forum FileMaker Pro 8.0
    Replies: 1
    Last Post: 01-16-2008, 01:40 PM
  4. Replies: 2
    Last Post: 11-18-2006, 04:49 PM
  5. making calc field data static
    By Marmot in forum FileMaker Pro 7.0
    Replies: 1
    Last Post: 04-30-2005, 07:38 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Welcome to the Original FileMaker Forum
With designated forums for almost every FileMaker topic...FileMaker Today is a free-to-join community where you can boost your FileMaker expertise, build better solutions and solve your technical challenges. If you're building FileMaker solutions, this is the place for you.
Follow FMT
We Are FMT
FMT is home of The World's leading FileMaker News Site, Worldwide Developer Directory, FileMaker Connect Community and so much more.