Can this be solved???

[balooka]

Hi,

I have a DB that lookups images in a related DB using an item#. There are however images that show more than one item and therefore are tagged with more than 1 item# in one line (like: item#1 item#2 item#3 etc). The problem is that when a user enters - lets say - item#2, the image wont show up, since its not an exeact match... Is there *any* way to work around this? I never tested the system for those multiple numbers and there are already over 9.000 images entered : So it's kinda hard to just re-write a part of it....

TIA

JP

[Razumovsky]

Hi,

I think a multi key would do the trick for you. In your photo DB create a calc field "MultiKey" that is defined as text:

item1&"PP"&

item2&"PP"&

item3&"pp"&...

that displays all the item names (or ID's)present in the photo for the record seperated by returns.

set your relationship from master file to photo file:

ItemName::MultiKey

HTH

-Raz