Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About bmill

  • Rank
  1. I am using a custom filemaker solution for medical office billing written with fp5 running on a mac with snow leopard. In addition, I have a patient management db (which I wrote) that is linked through pt. ID number to the billing program allowing transfer of some demographic information (name, DOB, etc). Other than being limited by hardware restrictions, the billing program serves our needs for now and upgrading to fp12 will take some time (and money). In the meantime, I am upgrading my pt. management program to fp13 and would like to move new patient demographic information from the bil
  2. Perfect! Finally got it to work! Thank you all so much for the great help and insight. Brian
  3. I have a DB for entering medical test results. Each patient has about 100 tests in five categories. To make data entry easier, I have a self-relating portal displaying the tests fields filtered by the five categories . A drop down menu with the list of test categories and script trigger sets the portal to display only tests in a category. If all results for a test category are the same , I want to to auto-enter the value chosen from a drop-down menu using a script trigger. The script loops through the visible portal setting the test-value in the result field if the test categ
  4. Thanks so much for the great ideas! I will give them a try and let you know how it works out.
  5. My limited experience and knowledge is the problem and I it is likely that I don't see the obvious. The allergen table is a rather large pick list (100+ items) and each allergen id is "imported" (maybe not the best term) from the list as a new record into the results table. Not all patients have the same number of tests run. The entire list of allergens can be imported into the results table from the allergen list table, measurements entered on tests that were run, and empty records deleted. I guess this would be the simplest method but creating 100 new records in the results table
  6. Thanks for the reply. I failed to mention that an additional two measurements using a stronger dose of allergen are sometimes made if the first result is negative, giving a total of four possible measurements for each pt. I have the tables and fields set up as you suggested. I would like to find a way to enter the test results quickly using the keyboard without having to to stop and activate a button to import measurements for each allergen id into the results table. I tried using a field as a script trigger to activate import scrip and move to next portal row when you tab int
  7. Looking for best solution for a medical record application. In an allergy office, patients have skin testing with a panel of allergens (bermuda grass, chocolate, etc). The reaction on the skin to each allergen is measured and recorded as two variables, wheal size and erythema (redness). Each patient may have a full panel (up to 66 tests) or just a few, and each patient may be retested at a later date. I have a table with the allergen list (about 100 records), a table of patients, and a results table with four measurement fields and test date, linked to the patient table. Re
  • Create New...

Important Information

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