simple relationship query

[Colin_Taylor]

Hi all

Have tax tables that need to be looked up off a total in a sub summary when sorted by name. Wont let me relate with a summary field. How do i get the daily wages to total other than using a summary field so that i can relate to the field in the sub summary or how do i relate the summary field that totals the daily wages to look up the tax tables as filemaker wont let me do it.

[comment]

Why don't you lookup the tax rate into the individual records? And by lookup, I mean really lookup - i.e. copy the current rate value - because tax rates change over time.

You also want to learn more about the GetSummary() function, I think.

[Colin_Taylor]

thanks for the reply. i appreciate it. The tax tables are based on fortnightly totals and so i cant add it to the individual records. Will look into the get(sumary) function.

[comment]

The tax tables are based on fortnightly totals

I don't understand this part. Please explain in more detail what you have, and what do you want to have.