Exporting a file from a Shared File Area to incorporate into a formula

[mjm19]

Run a query every day that accesses all patient data from yesterday. Now need to run a report against that query that searches for data from a selected population. That selected population is stored on the SFA in the form of an individual 's unit number (i.e. "1234567", "1234568&quot. Problem being that it is updated daily, and there are currently 3250 patient numbers on the list. Is there a formula / link out there that can capture that list from the SFA and make that part of the formula: Patient number is one of "that list" ? Then, if that patient was part of the original query the data would be there. This all resides within the same network.

 

[pgtek]

Hi
you must have a date time stamp to see the updated patient enter.
you can use this field to conditinnaly seek new patient added since the last entry.

patient_number should be your primary key

cheers
pgtek