Jump to content
Sign in to follow this  
Doug183

How to search for "non existant" on a referenced Table

Recommended Posts

End Result:

With two related tables, I want to search one ( Searching for 5 digit codes) and then find in a second related table all the records that don't exist (empty name).  

 

CURRENT FMP DATABASE/TABLES

Table 1 = NEO LIST.    Field:  NeoID. (7500 records)

Table 2 = CONTENTS.    Field:  FilmNameID.  ViewerName.   (6000 records)

NeoID and FilmNameID are related.

 

LAYOUT

Layout = NEO and references NEO LIST.  Its also displays CONTENTS::FilmNameID and  CONTENTS::ViewerName.

Search for a 5 digit NeoID, and the layout correctly shows 4000 results of NEO ID, CONTENTS::FilmNameID and  CONTENTS::ViewerName. 

 

FAILED SEARCH

I tried 2 different searches:

1)  Perform a find for all NeoID that are 5 digits  AND have empty CONTENTS::ViewerName.  So I  type ##### in NeoID  AND =  in  CONTENTS::ViewerName  (equal sign for empty).  However I get back no results.  

2)  Perform a find and type ##### in NeoID.  I get back 4000 results.  Then I type = in  CONTENTS::ViewerName  (equal sign for empty) and Requests >> Constrain Found Set.

3) Show all records in NEO.  Type = in  CONTENTS::ViewerName and I get no results.  

 

I think the issue is the that CONTENTS::ViewerName doesn't exist as opposed to empty.  Any suggestions?

 

Share this post


Link to post
Share on other sites

in table 2 do a find for * in a field it will find all occurrences with something present.

Choose Show Omitted (click the pie chart icon next to the record navigation) then in your other field in table 1 search for your code choose constrain found set from the records menu.

 

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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