Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About BruceJ

  • Rank
  • Birthday 01/26/1969

Profile Information

  • Gender
  • Location
    Kansas City
  • Interests
    Electronic Medical Records, hospital based

Contact Methods

  • Website URL
  1. I know what you mean, searching for ideal layouts and looks. I'm a psychologist and do a lot of work with industrial and organizational psychology. I have a strong appreciate for the way that people interact with machines, especially computers and the effects of colors and positioning. First - decide if your database is something that is going to be stared at all day long by users, or is it something that will be a quick reference that users will use for a matter of minutes at a time. If your users will be staring at your interface for hours at a time, you are responsible for a lar
  2. If you populate Global fields while running on the server, to content will only be showing for that user. Instead. Un-host the file. Populate the global field, and then host the file again. I'd prefer to use a separate small file with one record and many fields instead of globals, then use a calculation or script to pull the content into your file/record/field you want to use it. This way, you can change these "global" type of fields on the fly without "un-hosting" the whole ******* thing.
  3. Can you be more specific? What type of practice or level of care? e.g. Outpatient Family Practice, Psychiatric Inpatient Hospital, Optometrist Office, Nursing Home, etc. I do many solutions for inpatient and outpatient psychiatric hospitals and counseling offices. There's many fundamental differences depending on what type of service you are wanting to develop for. Also - are you wanting to include a business side of the EMR that includes Utilization Management or, god forbid... billing. Billing seems to be the bug that people have trouble with. My advice, don't reinvent
  4. I know this can't be that complicated, but let me make sure I get clarity on this because if I'm wrong, it will be too late to fix in the multi-user environment and will not be under my control to host and edit. My Understanding: In my preferences table with one record, I add regular fields (not global) and then in the same table, I add calc fields, stored globally that pull from the regular fields. Then, in the other tables that I want to use the preferences, I just refer to the global field even though it is in an unrelated table. When hosted on a server, one changes the
  5. Thanks for the suggestion to use globals. My concern, when this is hosted on a server, user A changes the preferences, but they only change for user A don't they? I understand that globals are ideal for a single user application, but if I want to global to cross over for all users in a multi-user environment, won't this get bungled up when it's hosted on the server? I know in the my past lives, the only way to get a global to show up for all users, was to take the application off of hosting, change the globals while in a single user environment and then host it back up on the se
  6. I'm having a brain fart... I'm setting up a Preferences table with company logos and other reference info, like sensitivity settings for a MetaPhone match, etc. I know I can only have ONE record and they should Not be globals (hosted multi-user database, FMP version 8.5). [color:red]My QUESTION Do I need to set up a matching relationship with every other table that's going to draw from the preferences record?
  7. I did this back w FMP3 and it was tricky to set up because the Citrix people didn't understand how FMP worked. Be sure they know you still need to run FMP on a server or partitioned drive just like you would if you were hosting it over a LAN. Then the actual application that is hosted by Citrix is the CLIENT version of FMP that has to be multi-user licensed otherwise, more than one instance of it running will act as if you've used a single user license on multiple machines and FMP is smart enough not to let this work. Usually, the company that wants to host via Citrix has their own
  8. I agree with this want... I hate all the work around stuff but I guess that's what allows us to charge more for our work.. ha ha ha... Kinda the same reason PhotoShop is so dang non-intuitive - to keep the rift raft out and make it seem like you need an expert to work it!
  9. If the Status area with the Rolodex is visible, the scrolling will flip from record to record. Without the status area showing, it just scrolls the screen.
  10. I think it's really good. It flows properly from Left to Right and Top to Bottom with what I understand is the work flow process. This is the natural direction that our eyes have been trained to scan and search. Only thing I can imagine is the bottom section with all the key date fields, you might put these on tabs to spread them out and hide many of them if they aren't always necessary... perhaps they are and a person needs to see all the dates at once to help make a decision. In this case, don't change a thing! I do prefer the delete button on the portal row and the "new button"
  11. It might be necessary to have two sources of addresses.. if a customers address changed then it would change any historical info on old orders, unless of course you also contained shipping addresses right in the order file that just looked-up the customer's address at time of shipping. I think this is getting more complicated than it has to be. I think the original question was how to see close or near match addresses to avoid duplication. To do this, I'd use some calc fields and relationships. Make a calc field that strips out any numbers or spaces in the street address in both th
  12. You may want to try using a portal instead of going into find mode and scripting it. To do this you have to have fields dedicated to entering find criteria. Then create a relationship between these fields and the target fields. This way you can just use check boxes for the grades to find and it will include all that you check.
  13. I can't even count tables let alone write accounting type software! Ha That's why I stick to medical/hospital stuff usually. The fourth table was really a Customer table in my mind, but not really a must have unless you plan on doing something with customers repeat business. I personally hate it when I go to buy a simple little widget and the clerk wants all my personal info... I'm paying with cash and want to be anonymous, especially when I'm buying my tin foil hat!
  14. The way I've done my point of sale applications includes Four tables: Inventory (kInventoryID, Description, StartingNumberOnHand, Calc_StartNumb_minus_SUM_QuantitySold) Invoice (kInvoiceID, CustomerID, Calc_SUM_TOTAL_of_LineItems) Line Items (kInvoiceID_Child, kInventoryID_Child, QuantiySold, PriceEach_LookUp, TOTAL_Qty_x_Price) Ok... here's the deal... in the Inventory you have a starting number of items on hand, simply subtract the sum of the quantity in the related line items. If you really need to track serial numbers of items on hand and items sold... then you hav
  15. Ok, as much as is pains me to say this, I have a quick and easy sure solution to exactly what you are trying to accomplish... Two words... [color:blue]QuickBooks It will even link to your bank account, keep inventory and all that fancy stuff. I'm all for being creative and independent, but why re-invent the wheel. It's like that old story about NASA spending thousands of dollars to develop a pen to write in zero gravity and varying air pressures.. very sophisticated. The Soviet Union faced the same problem, they used a pencil.
  • Create New...

Important Information

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