Search empty related fields

[Toni]

Hi

In a simple database which handles PBX data, i have two tables. On one there is a list of clients with their respective names and cell numbers, on the other there is the data received from PBX. On the last table I have created a relation based on the cell number.

Now, if a new number has been dialed, with a new number I mean a number which is not on the clients table, there is nothing displayed in the related field, it is empty.

If I execute a search to find the empty fields, it would find nothing because in fact on the clients table there does not exist empty fields.

How can I perform such find? How can I perfom a search to find numbers which are not on the clients table?

I could add the option to create records on the table based on that relation, the problem is that the relation is based on a calculated field.

Thank you Toni

[LaRetta]

Hi Toni,

In the Client's table, perform the following script:

Go to Related Record [ Show Only Related ; Match Found Set ; From table: PBX; Using Layout (based upon PBX).

Show Omitted Only

This will display all orphans, ie, PBX records without a Client.

LaRetta

Edited September 1, 2007 by Guest
corrected typo