Dear Filemakers,
I have a FM 8.5 clinical DB on XP. The patients in my DB are only for
research purposes but many related data are stored in another, huge
clinical DB (Microsoft SQL). I have access to that DB only as simple
user, I do not have enough rights to link the two DB.
Sayd that, I would like to create a script that launch the external DB
and loet me see immediately the clinical data regarding the specific
patient (the two DBs share the same primary key: the clinical chart
number).
Put simple i would like something this:
1) Export the clinical chart number from a specific FM field to the
clipboard (what command should I use ?)
2) Launch the external application
3) Log-in the clinical DB (user ID and password are required)
4) paste the clinical chart number in the search field of the clinical
DB
I was oriented to VB script for that, although I should learn the
basics on that.
Might you help me with ideas, links and sugestions ??
Thank you in advance
Diego
