nowayback Posted January 10, 2002 Share Posted January 10, 2002 Hi everyone, I have a portal with following relationship "Name::Customername", when a name is typed in the Name-field, the portal shows all the names that are identical to the name that is typed in the name-field. Is it possible that if i type a piece of a name in the field, the portal shows every name that consists that piece? For example: If i type '"ROB" in the name-field, the portal shows all the names that consist "ROB" (like ROB, ROBERT, ROBBY,....) GreetZ&Thanx in advance Link to comment Share on other sites More sharing options...
Thom Posted January 10, 2002 Share Posted January 10, 2002 Relationships only work with exact matches. If you enter "rob" in the left side match field, only those records with "rob" in the right side match field will show up in a portal. However, if a field has a return-separated list, FileMaker will try to match each line in that field. To accomplish what you want, you could use a calc field for the right side match field: 1 & " Link to comment Share on other sites More sharing options...
Kurt Knippel Posted January 10, 2002 Share Posted January 10, 2002 quote: Originally posted by Thom: Continue the pattern for up to 20 letters. Be aware that this will substantially increase the size of the file. I do not know if I would exactly say this. I'd bet that you will not even notice the difference. I have done many fields like this in to many files to count, and I have never noticed a file size difference. Although technically you are correct, and a full 20 character field should add approximately 231 bytes per record to the file, which is pretty insubstantial unless you have millions of records. Link to comment Share on other sites More sharing options...
nowayback Posted January 11, 2002 Author Share Posted January 11, 2002 Thanx for the information but (sorry for asking, i'm just a beginner) can you explain this formula please: nameMatch(calc,text)=if(isempty(name),1,name) Thanx Link to comment Share on other sites More sharing options...
Kurt Knippel Posted January 11, 2002 Share Posted January 11, 2002 quote: Originally posted by nowayback: nameMatch(calc,text)=if(isempty(name),1,name) This way is the Name field is empty the nameMatch will return a 1, if you look at the suggested calc for breaking the name field up, you will see that it starts with 1. So that an empty name will display ALL records rather than zero records in the portal. Link to comment Share on other sites More sharing options...
nowayback Posted January 14, 2002 Author Share Posted January 14, 2002 Thanx all, it works perfect !!! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8136 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now