Linking Tables

[Wiz Bang Computers]

I have two tables I am trying to link together and I would like to know if it is possible to do the link in a certain way.

Table A has a field called CELL CODE which will have one specific code placed in it.

Table B has a field called CELL CODE also which I would like to be able to put multiple codes in and have FM search for a match of code. The multiple codes woudl be in the same record. I have tried using a colen to separate the codes but FM is not seeint a match.

Is is possible to have FM do this relationship?

Thank you for your help

WizBang

[Kent Searight]

If I understand you correctly, you'd like them to relate in an "OR" type relationship. If so, just separate the key values with carriage returns in Table B.

[Wiz Bang Computers]

Kent,

Thank you very much! That was the solution I was looking for.