Relationship Using Field Containing Email Addresses
I'm trying to create a relationship between two tables using fields that contain email addresses. But because of the @ (operator), there's never a match. Anybody have a solution?
I just figured it out. I created a smaller file and did some testing - it doesn't like the Field with the storage/indexing of "Do Not Store Calculation results -- recalculate when needed." I unchecked that (and changed to ALL), and it works as one would expect!
thanks for your help!
The @ symbol will not keep two text fields from matching in a fileMaker relationship. If this isn't working for you, there must be some other issue involved.
one of the fields is a calculation (Lower(User Name) & "@" & Domain Name) - but both are text. Could that be the issue?
The matching is not case sensitive, so the user of the Lower function is not an issue. What storage/indexing options are selected for both fields?
The one is Indexing: All and the Calculated field is Do Not Store Calculation results -- recalculate when needed.
One? All? I'm not sure I follow that. An unstored field has limitations in how it can be used in a relationship.
If I have:
Table1::UnstoredField = Table2::StoredIndexedField
I can view/edit related records from Table2 on a layout based on Table1, but I won't be able to view/edit records in table 1 from a layout based on Table2.
Retrieving data ...