>Hi Doug,
>
>I have another question. I have a Phones table where type identifies the kind of the Phone. Suppose, I'd like to combine two Phones in one field (separated with Chr(13), so it would become Memo field). Is there a way to do so with Stonefield Configuration Utility?
>
>In VFP I would probably create a left join with the same table twice but how can I create a combined field?
>
Hi Naomi,
I am not Doug <g>, but I use Stonefield Query quite a bit.
You could do on eof two things, that I can think of:
1. create a calculated field in your table in the config utility, or
2. create a SELECT script for the table which has your own code combining the two fields into one.
Number 1. is probably easier to do.