Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

simple relationship query

Colin_Taylor
in Relationships

Featured Replies

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.

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.

  • Author

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.

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.

Create an account or sign in to comment

https://fmforums.com/topic/74786-simple-relationship-query/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.