Hi Doug & everybody,

I've sent an e-mail to the development team with this question, but I also want to ask here in case anyone had the same problem.

We have a People table and a Phones table where we have Phone and Type fields.

Now, in the report I'd like to show

Last Name First Name Home Phone(s) Office Phone(s) Cell Phone(s) E-Mail(s)

I tried to approach this problem in two ways.

1. Using new fields in the People table with custom scripts - this approach seems to be too slow - is there a way to speed it up?

2. By Creating 5 different subtables for the different type of Phones, adding complex join (left join) relations to the People table

Sample of the relation: LEFT JOIN

People.CID = Phones_Office.CID and Phones_Office.Type = 'Office' and Phones_Office.PHONE <> space(60)

Many - Phones_Office
One - People

Somehow it looks like using this approach behaves as an Inner JOIN. E.g. if I include only Home Phone I see ~768 records, but adding Cell Phone reduces the number of records to ~200.

Do you know how should I solve this problem?

Thanks a lot in advance.