More than one field to relate

[Toni]

Hi, may be just discussed but I'm not able to search it, apologise me.

Here it goes. I do have a simple database file in which are stored the contacts of my company, among other fields there are their phone number in one field and their cel number in another field.

On another databse file, I get the data from our PBX (central telephone). This PBX will generate a txt file with calls made from inside to outside.

Now I want to build a relation, so that when the phone number in the PBX based will display, it will show the name of the person to which it belongs getting it from the first database. It's pretty simple so far. The problem comes because I want to relate it with the cell number too. The schema will be like this:

Call ID - is the field in the second file with the number been called

CellNum - is the field in the first file with cell number

TelNum - is the field in the first file with tel number

To build my relation i thought of sth. like this:

Call ID = CellNum or Call ID = TelNum

But in the FMP7 instead of "or" when you want to add a relation it goes "and".

Any idea how to work around with this?

Thank you in advance, Toni

[Osman]

You can create relation by or operator with the help of calculation.

First define a calculation field which is equals to:

CellNum &"return character"&TelNum

Then build your relation as like this:

CallID = New_Calculation_Field

[Toni]

Uau, thanks a lot.It worked