Search on a repeating field

[jhomer]

some quick background... we have an inventory file with a list of tag numbers, its an old solution we are in the process of rewriting, but for now we use repeating fields to enter a new tag number to a coil if per say we cut part of it then return the rest of the material to stock... when this happens we assign a new tag number...

If we try to do a search on anything but the original tag number we get no return results???

anyone have any ideas as to why this may be happening or anyone encounter the same problems??

as always any comments are appreciated..thanks

[T-Square]

I cannot comment on why your search fails, but I might suggest that you spin the repeating field entries out into a related table, which has a field for the Inventory ID and a single tag number. Each Inventory/TagID pair would have a separate record in this table, and the search would be very straightforward. Display and edit the tags by creating a portal for the Tag records on your layout.

I don't think such a migration would entail a great deal of work, and the results would be great.

David

[mr_vodka]

:iagree:

I agree with T-Square 100%. You really should think about seperating them out from repeating fields. Considering that you are running FM7, it should be fairly easy to create a new related table with the related data.