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.

counting entries in a related table

yellowcake
in The Left Brain

Featured Replies

Hi Guys, i'll try to explain the question. I have a main table (this table contains the info about the job). I have a revisions table thats related to that job number - and i want to assign a revisions number to each entry - expect that when a new record is taken out on the main table - i need the revision to be reset back to 0.

IE.. job number 123 (main) has (revisions) 1, 2, 3

Job number 124 (main) has (revision) 1, 2

Job number 125 (main) has (revision) 1, 2,3,4,5

hope that makes sense

Cheers

AL

and so on.

Im sure that thsi is a very easy thing to do, but im stuck on it.. any help would be very much appreciated

Cheers

Al

  • Author

heh .. solved it after looking for complicated calculations... it was as simple as putting @@ in the row portal!

There you go.. sometime the solution is right in front of you but you cant see it for looking hey!

Cheers

Al

Create an account or sign in to comment

https://fmforums.com/topic/66647-counting-entries-in-a-related-table/
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.