Jump to content
  • 0

Solution - View of IDs Based on 2 Fields


ChristianM
 Share

Question

Thought this might help anyone struggling as I did to create a View of only IDs (1) not duplicated between two tables or (2) duplicated between two tables but a second field is a certain value.

I have two tables:

1. Table A - has a list of every available ID

2. Table B - contains IDs of inserted records (can have same ID on multiple records)

I did a full outer join on the two tables in a View based on the ID

image.png.37c1fd98c0cb005d443bd9bf4038bbd5.png

First criteria only show IDs that are in Table A but not in Table B

image.png.2c8f8726576393d379d84e2652b773d3.png

 

I then only want to include IDs if the record is in Table A and Table B, but a second field has a value of "Yes". However, Table B can have multiple records with the same ID with the second field with values of "Yes" or "No". The Not Equal filter wouldn't work because you can't NOT at the AND level.

To solve this I added a sub-AND filter with two lines stipulating what I wanted the field to be and what I wanted it not to be.

image.png.a842f6dbe6376542b99a4154c7fad5ba.png

Link to comment
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

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
Answer this question...

×   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.

Loading...
 Share

×
×
  • Create New...