Can FileMaker do this?

[Ham]

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?

[aaa]

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.

[Søren Dyhr]

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

--sd

salaries.zip

[Ham]

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

[Søren Dyhr]

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

[Ham]

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!!