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.

searches and subsets in related tables

Featured Replies

This is probably a very easy procedure, but I can't seem to figure it out.

I have two tables: clientInfo and projects

the two tables are linked via the field clientID

I would to list projects between certain dates, eg, >1/1/10 and <12/31/10. I did this using search of the start and end dates of the projects to generate a subset of projects that were started and finished in 2010

How do I get this subset in another layout which lists the clientinfo? Usually, all i have to do is switch between layouts and the subset info is maintained. But then I switch from the projects layout to the clientinfo layout, the subset info is not carried along.

Thanks for you help in advance

Since you've properly related Projects to Clients by storing the foreign Client ID in Projects, all you need to do is place the related Client fields on your project layout.

Your date search will exclude 1/1/10 and 12/31/10, btw. You need <=. You could also just use */*/2010.

How do I get this subset in another layout which lists the clientinfo?

If you want to find clients that have at least one project in a date range, perform the search from a layout of Clients - entering the search criteria into the related fields from Projects.

Another option is to find the relevant projects, then Go to Related Record [from Clients; Match found set].

Create an account or sign in to comment

Important Information

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

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.