isolate orphan and missing parent data

[Rainy Pass]

I have two (many actually) related tables. Each table contains orphan records and missing parent records. What is the best way to identify records that need additions to their related table(s)?

Table A

x

y

z

Table B

w

w

x

x

z

How do I isolate w and y to add the respected records to make the sets complete?

[comment]

Try searching for * in the related matchfield, then show omitted only.

[Rainy Pass]

Is there a way do do this with relationships? Would like to have this info shown "live" as data changes are made.

[comment]

You could place a related field on the layout and format it conditionally to flag the empty ones - if that's what you mean.

[Rainy Pass]

I have tens of thousands of records in one of the tables. I would like a easier method than scrolling long lists.

I think I can pull the values out of each table into a global record using ValueListItems and List functions. The Filter function can show the common values.

Do you know of a way to extract the values missing on one side? Basically the inverse of the FilterValues function.

[comment]

I am afraid you have lost me. What exactly do you want to see "live" and from where? A little background and real table/field names would also help.

[alex45]

The warm feeling I get when someone is thoughtful enough to say thank you for having been helped far outweighs the empty one I get when there's no feedback at all.

[Rainy Pass]

I want to see in a portal, a list of all the style numbers from test UPCList, that are missing from Test StyleList.

See TestMissing layout in the attached file.

By "live" I was referring to using a relationship to show the data. Sorry for the slopply terminology.

Thanks for looking at this.

After reducing the number of records in this file, I noticed the list fields do not update. Do you know why?

MissingData__test.fp7.zip

[comment]

I am afraid it would take me days to find my way in your file. Why not post a simpler one, showing only what's needed to understand the issue?

I noticed the list fields do not update. Do you know why?

Try making the calculations unstored (not global).

[Rainy Pass]

The clean version...

Sorry to be such a pain

MissingData__test.fp7.zip

[bruceR]

I have tens of thousands of records in one of the tables. I would like a easier method than scrolling long lists.

I think I can pull the values out of each table into a global record using ValueListItems and List functions. The Filter function can show the common values.

Do you know of a way to extract the values missing on one side? Basically the inverse of the FilterValues function.

AntiFilterValues:

http://www.briandunning.com/cf/926

[comment]

I still don't get your file, but perhaps this might help?

NonMatches.fp7.zip

[Rainy Pass]

Thanks to both of you. I've got it, finally.