Jump to content

PathGeek

Members
  • Content count

    24
  • Joined

  • Last visited

Community Reputation

0 Neutral

About PathGeek

  • Rank
    novice

Profile Information

  • Gender
    Not Telling
  • Location
    Seattle

Contact Methods

  • Skype
    micro2nd

FileMaker Experience

  • Skill Level
    Beginner
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    Sierra
  1. PathGeek

    Category and sub category

    following this guide I attempted to create a DB with one more subsumed level [ideally I'd like 2 subsumptions], as I'm attempting to create a DB with Tests/TestName/TestResult/TestResultText The value list condition I set was Table3:LevelThreeItem Include items related from 2nd table (labeled Items in your example). In Layout mode I have tried using Table1(list) and Table2(aka Item) list and do not get the third level option to show (says missing values, although I created values for Table3 ) So obviously I didn't understand the concept well enough 1) Is my value list wrong? 2) is the relationship wrong? 3) is the field designation on the layout wrong? Any guidance would be appreciated. ConditionalValueListLevelThree.fmp12
  2. PathGeek

    Problems with Case function

    I've been soaking this thread up and loving it. Then came to Harry's last post and pfffffff when the balloon I'd like to thank Harry for sparking this repartee (not "repartay" and pardon the parens !) and wish he'd have been able enjoy the philosophical swordplay. I'm so new to this that the cushions still smell of chemical freshner-- and I really appreciate hearing the back and forth about best practice.
  3. PathGeek

    ISO Relationships 101?

    So, after much thinking about what you said, EOS and COMMENT I've read about and drawn many entity relationship diagrams, worked on a very basic model, and have attached it. At least some of the relationships I was trying to define are now working! Obviously I'm not even skimming the surface. But, this is FUN! Eos, I do have questions for you about your schema what did you envision as possible values for "test items"? Were you thinking (Week 2 Test---- questions in week2 test)? do you see anything in my solution that would require a test item table? The test results / result sections are different in different Lab/Tests, so am wondering how to deal with that. Molecular/TestX /Results: generally all have same format, which works well as I have it currently Flow cytometry/TestX /Results have a different format not sure how I put that into Generic(ResultsTable) is there a way to do that or do you think I'll need to split to have MoleTests/MoleTestResults and FlowTests/FlowTest/Results If only one table, will formatting of results need to be via calculation or more scripted? Wish my day job actually allowed me to think about this during best brain time. Thanks for your continued help. Testv101.fmp12.zip
  4. PathGeek

    ISO Relationships 101?

    Many thanks, eos- just saw the posting. I've downloaded and will try to wrap my head around the RG. thanks for the time you've taken to help me understand. besten Dank u. mfG
  5. PathGeek

    ISO Relationships 101?

    Have attached what I've been playing with so far. I'm sure i have more questions than this, but here goes: patient-- don't really understand how to associate patientID / to HLID (our internal patient number), and individual tests in the Tests table Why isn't the tesst name showing up in the browsemode (or in the calculation for the CreateTheReport table? If a test has an assigned number (Say 1 = jak2) -- how can I either select TestNumber or TestName and have the other columns lookup the value? How can the tests_Laboratory be set to look-up and fill with the lab name if test name is chosen or vice versa (if Lab, the TestName will allow pulldown of the tests offered by Lab) CreateReport Table Test name shows only number (so it's consistent) Methods from referred table is obviously not set up correctly It seems I have a recurrent lack of understanding about this still. Continued help is greatly appreciated. Test.fmp12.zip
  6. PathGeek

    ISO Relationships 101?

    The possible results for a test are many pos/neg/mutated/unmutated/suspicious/fail, etc For each patient specimen, a specific test can have one result MrSmith--Jak2--Positive, Homozygous currently we have 5 labs. patients can have tests in more than one lab and more than one test within a lab --- we've decided to leave the linkage of (if TestA is negative, automatically do TestB) out of the FM solution initially patients can be tested over time, such that tests / results for each isolated test would need to be captured as some of the tests have quantitative information that is monitoried On the functionality bit-- trying to explain what this needs to do so I can figure out the how to build the bridge to get there Thanks in advance
  7. PathGeek

    ISO Relationships 101?

    Hello all. Have been working with FM for a bit, but still have very basic problems with relationships— help appreciated. Background Work in a laboratory and am needing to create a db w/ labs, tests, and report content Functionality: The user example: tech from LabID= 2 (Molecular lab) ) should be able to select TESTS from the lab in question example: JAK2 test then select the result ( positive / negative etc) and that selection should populate results (TestTitle, TestResult, TestResultText, So far this my thought process is: Table1: Labs with LabID (serial# auto generated) and Labs Labs (Molecular, Flow cytometry, cytogenetics,…. etc Table2: Tests: TestID, Test, and kf_LabID example above from Molecular Lab Test =JAK2 (the table contains name of test, test methodologies) Table3: Results: resultID, result, kf_TestID example above positive (heterozygous / homozygous) or negative Table contains Text, Reference, Comments associated w/ the result Table4: Join: JoinID, LabID, TestID, resultID I think my TOCs should be something like this: Join : Join Table1: Labs " 2: Tests Test~Tests in Labs " 3: Results Results~Results in Tests This is as far as I get. I;ve tried to build things and get stuck every time. Questions: 1: How do I actually put these together? 2: where do I put the patient identifier (Patient#)? 3: How do I build this so that patientID and PatientTests can be joined so that I can monitor results if a patient has more than one test over time? Thanks in advance.
  8. Just updated from FM10 AdvPro to FM11 AdvP. I have a DB(from v.10) with very specialized vocab; with upgrade the dictionary is, of course, without my laboriously managed library. Can I find and import my v10 library to v11? Where might I find it? How would I do that? TIA
  9. PathGeek

    Documenting Schema

    Are we assuming you have tried the Database Design Report under the Tools bar.....?
  10. PathGeek

    Portal vs Relationship question...

    This is a leap in the right direction for me, thanks! I spent the weekend reading about relationships and came up with something "close" but missing the JOIN tables, which make all the difference. Need to read more on how that works. Thanks for your help!
  11. PathGeek

    Portal vs Relationship question...

    Thanks, Peter. I've looked at this and think it's way beyond my knowledge scope.... anyone have any work-arounds for a newbie?
  12. In trying to create a patient/disease database for use in my blood pathology practice I am running into problems. My intent is to have patient information and Disease/diagnosis. Selecting a diagnosis should bring up salient criteria/features of the disease for viewing, classification criteria and an industry standard diagnosis "checklist". Classification schemes vary with organ systems; schemes and checklists will version-change with time. The Patient Table includes items such as NameFirst, NameLast, DOB The confusion is in how to create the disease side of the database; I may be making this more confusing than needed, but Diseases and their classifications have many sub-sets. I'd appreciate help in how to set up the tables/portals. I think I need tables for ClassificationScheme, OrganSystems, and OrganSystemSpecificDiagnosis but have no idea how to represent this is tables or portals... Have attached an image in attempt to more aptly describe... TIA
  13. PathGeek

    ? duplicate serial-- how to merge records

    I was "doe in the headlights" when I found this out-- the option to manually change the serial number is logical. Thanks for the help!
  14. Somehow I have a duplicate in an auto-enter serial, indexed "PatientID"... so that "sally" and "dick" have the same ID number; sally's tests are really dick's (with one modifiable exception), and dick's are dick's. Question 1: what happens if I delete "sally" (will Dick's records disappear?) 2: can I merge the records and make sally disappear without losing all of the information which is valid to Dick's medical record? hope this makes sense...
  15. PathGeek

    New to FM and Databases... Beginner Question

    Obvious. and I didn't see it. Thanks.
×

Important Information

By using this site, you agree to our Terms of Use.