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.

finding ALL related records

  •
MJK.NSW
in Finding & Searching

Featured Replies

Hi,

I've 2 tables, Jobs and Invoices. Each job can have a number of invoices

What I want to do is find all the invoices done in November, but also include in the found record set all the other invoices for those jobs which did have at least one invoice in November.

I thought it would be easy but I come to a complete block

cheers in advance

MJK

Find the jobs that did have at least one invoice in November. Then do Go to Related Record [from Invoices; Match found set].

  • Author

hmmm... must be doing something wrong

layout is based on Jobs table, using the TO jobs_invoices_JobID to find 115 invoices done in November (a couple of Jobs had more than 1 in Nov and the found set shows them), then goto related match found set but still only get 115 records - shoud be another 20 odd

  • Author

ah! I was using the same layout and needed to change layouts in the go to related records bit !

thanks

Create an account or sign in to comment
Go to topic listing

Similar Content

Important Information

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

I accept

Account

Navigation

Search

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.