Jump to content

More than one field to relate


Toni
 Share

This topic is 5593 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 5593 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.