Show "Add" if ID is not already in table

I have two tables linked together by unique ID numbers in an ID column in both tables. One is a top level "Employees" table and the other is a table acting as a database for various dates stored in one row for each linked ID called "Updates." I do not want to show the "Add" option in the automatically generated inline ref view at the bottom of the EEs_Detail view if the ID already exists in the 'Updates' table. In this case, ideally, all that would show is an edit action in place of the system generated View and Add actions.

I've tried several different expressions to try and make this happen and I am coming up short. I have a feeling its because the data I am searching for, the ID, is a Ref type. Any help with the proper expression is much appreciated!!!

Thanks in advance,

Daryl

Solved Solved
0 12 534
1 ACCEPTED SOLUTION

Use the [Related...] VC in your COUNT(). 

View solution in original post

12 REPLIES 12
Top Labels in this Space