before someone jumps in... no i cant add a field to the emailaddresses table... that data is flushed everyday... and if they are in the opt-out table we will ignore them...
On a layout to which table do you want to see this value list?
You could use a relationship like:
EmailAddressesTable::EmailAddress ≠ OptOutEmailAddressesTable::EmailAddress
In a conditional value list that lists values from EmailAddresses and specifies the opt out table as it's "starting from" table.
But that only works on a layout based on the OptOut table.
On the OptOut layout I want the email address list to only show addresses that are not in the opt out table.
I tried your approach previously, and got all email addresses, minus the current record in the opt out layout.
Other funny thing is I only got results in the value list when there was an email address in the opt out record, when I tried to add a new record, opt out email was empty, and so is the value list.
Apologies, I posted too soon. I had a little demo file going that seemed to work, but after reading your last post, I went back and tested it again and see the same issues you describe. I'll keep fooling around with it and if I get something that works, I'll post back.
Please disregard my last post.
Got it!. See this demo: http://www.4shared.com/file/238396712/1bc6c8f9/NotEqualCondValueList.html
It took a bit of creativity but here's what I did:
Defined a self join between the OptOut table and itself using the cartesian join operator "X" so that it matched all values in the opt out table.
I named this new table occurrence "AllOptOutEmails"
I defined a new calculation field in the OptOut table as cAllOptOuts : List ( OptOutEmails::Address )
I then linked the OptOut table to the email table by this calculation field instead of just the email table. Now the conditional value list that uses this relationship works.