I'm using this format for my calculation.
"Part Number & " " & VT & ".JPG"
Can you use a wildcard for the ".JPG"?
"Part Number & " " & VT & ".*" ?
I tried this but did not work.
Wild cards can only be used as find criteria. Different wild card can be used in an SQL query.
are you searching for file names in a text field with that name but with any extension?
Yes! It could be ".JPEG", ".PNG".
Can you perform this find manually? If you're in a script, make sure your calculation happens before you enter find mode.
I do not have a "Script" for my situation. I used a Formula in Manage Data base.
I guess that means that you have a relationship based on this field? I'm curious what others will suggest. I'll cypher on it as well.
As far as I know, you can't use wildcards in a relationship.
David and phil
Thanks for your reply's
Retrieving data ...