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.

Search empty related fields

Toni
in Finding & Searching

Featured Replies

Hi

In a simple database which handles PBX data, i have two tables. On one there is a list of clients with their respective names and cell numbers, on the other there is the data received from PBX. On the last table I have created a relation based on the cell number.

Now, if a new number has been dialed, with a new number I mean a number which is not on the clients table, there is nothing displayed in the related field, it is empty.

If I execute a search to find the empty fields, it would find nothing because in fact on the clients table there does not exist empty fields.

How can I perform such find? How can I perfom a search to find numbers which are not on the clients table?

I could add the option to create records on the table based on that relation, the problem is that the relation is based on a calculated field.

Thank you Toni

Hi Toni,

In the Client's table, perform the following script:

Go to Related Record [ Show Only Related ; Match Found Set ; From table: PBX; Using Layout (based upon PBX).

Show Omitted Only

This will display all orphans, ie, PBX records without a Client. :wink2:

LaRetta

Edited by Guest
corrected typo

Create an account or sign in to comment

https://fmforums.com/topic/54564-search-empty-related-fields/
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.