automating data importing

[yalon]

Hi,

I am new to FMP. I have created a database for one department I work for (free of charge of course cause I'm a sucker). Now I have been asked to build another database for another department I am involved with. It is a hospital department. There already exists a database of patients that the hospital manages based on appointment times. the individual departments can access this database to find out who has appointments on certain days. My question is whether or not there is a way to create a script that would run at startup that would import records of all patients coming that day. The secretaries would then enter additional info but the name, age, etc, would be imported automatically at startup.

Any suggestions?

thanks

yalon

Edited November 30, 2007 by Guest

[cjaeger]

Ever considered sharing the first database? Then it can be all done with clever relations.

[yalon]

well i don't manage the 1st database. The hospital does. In fact its not even a FMP database. Maybe i should clarify my question. I was wondering if anyone has experience with importing data from another database regardless of whether that other database is a FMP database or not. I also ned this to be done automatically at startup so is there a script that I could create to do this. i know there is a "run script at startup" option and I know there is a "import records" feature that allows one to import data from another database. I just want to know if anyone has experience with this and what potential problems might arise.

[TASC]

we do this with our database by importing the record information where the one field is the same in both databases.

eg.

import records as

select ename from emp where empno = 10

and the ename will be imported if empno in the filemaker db matches empno in the other db (in my case, oracle)

Hope that makes sense,

Constance