vyoung Posted November 11, 2001 Share Posted November 11, 2001 I created a billing database which creates patient charge sheets for surgical procedures. I created a handheld DB on HanDbase which I have successfully ODBC linked to the FM billing db, such that all non calculable fields can be entered on the handheld, synced, and transferred into FM for calculation and printing of charge sheets. I am trying to configure a script which will know which records are new or updated and then only print those records. I thought of using a range find from the "insert from last record" (date)to "insert current date", but I fear it will use the last updated record since this is the last active field and I will get one day of records printed instead of say the last week if the last time the records were printed was a week ago. Any ideas where to start? Currently I sync, manually perform a range find, then manually print the found set. Thanks in advance. Link to comment Share on other sites More sharing options...
Anatoli Posted November 12, 2001 Share Posted November 12, 2001 Maybe best will be to set flag after printing "printed" in one field and clear that flag when updating the main database. Link to comment Share on other sites More sharing options...
vyoung Posted November 13, 2001 Author Share Posted November 13, 2001 I created a printed field and place a Y in the field for records that are printed, so that new imported records are without a Y. Then I created a script with a find that finds all Y records and then shows omitted records (the new records) and prints them. Now the part I cant seem to figure out. I used the insert text script placing Y into the printed field, however it only places a Y in the current record (not the found set of records) then I tried the replace script, but it wants to use the Current text which is nothing for a new record, a serial number, or a calculated field. I guess I could create a number instead of Y, then create a calculation field that calculates that number and places it in that field, seems a bit of a run around though. Any ideas. Link to comment Share on other sites More sharing options...
Vaughan Posted November 13, 2001 Share Posted November 13, 2001 That's the way: make a script that... Set field [ inserts the "Y"] Replace [field, no dialog] Link to comment Share on other sites More sharing options...
vyoung Posted November 15, 2001 Author Share Posted November 15, 2001 Worked like a charm. At first I tried one and then the other, I didn't think to try one followed by the other. Thanks. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8198 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now