lacinda

I am setting up an insurance billing database for use via IWP, and I am having some trouble getting the "reporting" interface right. I'm trying to do this with a portal...this may not be the best way. Basically, I am tracking patient visits for each month. There are 3 types of patient visits available, and different combinations of those visits result in different billing codes that are sent to insurance. I am having trouble building the layout that the doctors will look at to see the status of patients in a certain clinic. I have a patient_demographics table linked to a patient_visits table (one-to-many) via a patientID field. The visit table has the information I'm really interested in - the visit date, the visit type (clinic, ST visit, or FF visit) and the visit location. My "dream" layout would have just the dates of the visits for that month, by type: [demo::patientID] [demo::patientLN] [demo::patientFN] [visit::clinic visit date] [visit::ST visit date] [visit::FF#1 date] [visit::FF #2 date] [visit::FF#3 date] [visit::FF#4 date] I *can* get a "standard" style (1 visit per line) portal, filtered for the specified month & visit location. The layout is based on table:patient_demographics, so there is only 1 line per patient. The portal is based on the related visits table. I run into trouble trying to get the visit dates inline...I tried to create 6 "one-field" portals (with "visit::visit_date as the field), and then filter each portal based on visit type (so, the 1st one is visit type = "clinic", 2nd one is visit type = "st", 3rd one is visit type = "ff", 4th one is visit type = "ff" + show 2nd record...etc). When I do the one-field portals, it shows the records for all visits, not those of this particular patient. I have also tried creating multiple relationships to do the filtering, but things got confusing fast. I have a habit of making things too complicated...Hopefully someone will be able to help. Thanks, Lacinda

i finally solved it...by formatting the drive and starting over. i only had one mac having this problem (out of about 100) - it was relatively new and the user was complaining relentlessly. good luck!

Yes, it does have a Page Setup [restore] in it. I do not know what page setup it is restoring - can you tell me how to figure that out? I can get in and see the scripts but I can not see how to define anything. Here is a script that works (differences noted by bold face). The same layout is used in both (denoted with xxxx list). We'll call this one "Daily": Enter Browse Mode [] Go to Layout ["xxxx List"] Page Setup [Restore, No dialog] [color:"brown"]Enter Find Mode [Pause] Perform Find [Replace Found Set] Sort [Restore, No dialog] Enter Preview Mode [Pause] and the one that doesn't...we'll call this one "All" Enter Browse Mode [] Go to Layout ["xxxx List"] Page Setup [Restore, No dialog] Perform Find [[color:"brown"]Restore, Replace Found Set] Sort [Restore, No dialog] Enter Preview Mode [Pause] [color:"brown"] Enter Browse Mode [] I get various error messages when I try to change the "All" script to match the "Daily" script, including the pictwstops error and "Error Drawing page 1". Any ideas?

I've tried drivers from the hp disk and a newer one on hp's site. (It's an hp 4200). i'm not ruling it out, but i've reinstalled the printer a couple times (with different drivers). Like I said, the printer is able to print multiple records otherwise; it's only after the script is run that I have problems. BUT - I've used this script before without problem. Other people in my dept. are using the same script without problem. I'm at a loss... EDIT: I receive the same errors when I try to print to other network printers (different models). These other printers are used by others successfully.

I am having problems printing a select set of records that are selected via a script. I can print a record or group of records from the database without incident. After the script runs, the "preview" of the number of pages shows "?" pages (instead of a number). When I try to Print directly, it cycles through the number of records (Printing Page 1...Page 2...etc), but when it gets to the end, it doesn't do anything! The print center will flash the message "pictwstops - got an error disposing of document. error -8986" but this goes away after a few seconds. If I try to do a print preview from the Print dialog box, it gives me the following error message. "Sorry, FileMaker is unable to continue printing. Error -9705". I saw on the FMP website that this error means there is a problem with a font that was not installed under OS X that was used to create the database in OS 9. So, I went in to layout mode, selected all, and changed the font to "Arial". Still no change. This did happen after an upgrade of FMP 5 (maybe 5.5) which was running in Classic mode, to FMP 6. But I can't figure out how to fix it. Any suggestions? TIA, lacinda