I am creating a Database which divided to two parts, first part is personal information, and second part is salary calculation plus timecard

so on first part i use "only show related record" from another table, so I can choice difference month salary record... now there is a problem,

in one field of salary record, I need to know the field result from previous monthly record, so what command should I use and how to write the script?

Create one global field Month and relation by this field (let with MMM name) to your records and near your salary field show MMM::Salary and Month. Now if you in Month field put neccessary month in MMM::Salary you can see Salary for this month.

This is one of ways, which you can go, in all case the solution is depend from building of your database.

Another way to handle the matter is like this...view template attached.

--sd

salaries.zip

Thanks a lot SD, your sample file is excellent, but I have try my best to put your concerpt to match my existing file, but seens not working

do you think I can send you the file and you can see where is the problem?

Thank you SD

do you think I can send you the file and you can see where is the problem?

You can, but beware I'm leaving for Devcon saturday 11:00 AM GMT ...so if it's just a tiny matter, please do ...but if you file takes a lot of digging - you'll have to wait a week or so.

--sd

Thank you SD, Thank you very much, I have use your concept and finally makes the function works

and I am getting more known about Filemaker Pro, Thank you very much!!!

Thank you!!