Ham Posted August 23, 2005 Share Posted August 23, 2005 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? Link to comment Share on other sites More sharing options...
aaa Posted August 23, 2005 Share Posted August 23, 2005 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. Link to comment Share on other sites More sharing options...
Søren Dyhr Posted August 23, 2005 Share Posted August 23, 2005 Another way to handle the matter is like this...view template attached. --sd salaries.zip Link to comment Share on other sites More sharing options...
Ham Posted August 24, 2005 Author Share Posted August 24, 2005 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 Link to comment Share on other sites More sharing options...
Søren Dyhr Posted August 24, 2005 Share Posted August 24, 2005 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 Link to comment Share on other sites More sharing options...
Ham Posted August 25, 2005 Author Share Posted August 25, 2005 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!! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6679 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now