god of pettiness

If I put every possibility in the related field separated by a return, I can change the match field, and the results in the portal change! Sir, you rock. [This message has been edited by god of pettiness (edited January 17, 2001).]

Unfortunately No. See, I'm trying to re-use this portal based on the four select fields that the user sets, then they hit a button that sets related fields in related records (Sales related through a customer code) to have a value that gets concatenated in the same way as the match field. The difficulty arrives when the user blanks out a field. Then that part of the concatenation has no value. It's not a huge deal, since I have this solved with my Replace script (sort of described in previous email. But for efficiencies sake, I'm making an export of all records modified since the last export time stamp. With me constantly replacing this field the modification field gets updated every time I try to display those darn ads. Is there no way to make a logical match? the guide mentions a Unit Price > 100.0 example. Could I do a simlar text calculation that relates records that contain given chunks of text?

quote: Originally posted by Chuck: Can you give a more specific example? How will FileMaker know how to match the fields? A good way to begin would be to ask how you would know that the records should match. If we can figure that out we can probably use calculations to help FileMaker figure it out. Chuck Well, I've got a calculation field that concatenates 4 test fields. I want to display records in a portal, but I'm trying to dynamically qualify it so that while 15000 records match my Client Code field, only 40 of those match the Release Date field. That's straight forward, but if I want to show records in the portal that match just the release date (say 10000 records alltogether) it won't work now, because the related field doesn't match the match field 100%. I want to avoid modifying the related record every time I play around with those source-for-calculation fields (by replacing the related field, or similar)

I'm trying to make a relationship between two records based on a text field. This text field in the Master file may not contain all the same text as the related field, but the related field would contain all the text in the Master File match field. Filemaker book says Formulas work, but is that only for numbers? Can someone suggest how this might work?