Yes it is normal behavior just as repeaters are multiple values in relationships or multilines search each line value separately. Also searching for duplicates using =, a multiline will treat each line as possible match. :-)
So if I setup a relationship between a a single field in TableA and a Repeating Field in TableB. In a portal showing records in TableB on a layout based on TableA I will see all records in the portal that has a matching value in any repeat in the field in TableB? Is this correct?
Never tried this, could be helpful. I started with FileMaker 8.5 and followed the advice in many of the FileMaker books at the time that indicated not to use repeating fields for data. Use tables and primary key/foreign key relationships instead. I also remember seeing a bunch of list items at the itme about how "do I get the data out of my repeating field now that I converting from an early (Pre 7 ) version to current version". Result, I haven't used repeating field very much.
1 of 1 people found this helpful
Bruce Herbach wrote:
So if I setup a relationship between a a single field in TableA and a Repeating Field in TableB. In a portal showing records in TableB on a layout based on TableA I will see all records in the portal that has a matching value in a repeat in the field in TableB? Is this correct?
Yes it will work. But in general repeating fields violate one fact per field and should not hold data unless 1) for Developer use in displaying, calculating or otherwise manipulating existing data from regular fields or 2) one is a Repeater Master. I am not a Repeater Master http://fmforums.com/forum/topic/55005-join-trs-today-only-open-minded-people-welcome/#267370 . Most times even they will recommend against using repeaters for data. I DO think repeaters are nifty though.
UPDATE: BTW, the buttons I said I would give out (in that thread) were a joke ... I had several people contact me to get one. I gave them a high-five instead, LOL.