Shape command

Hi ,
I have a customer table, a customer_services table and a services
table,

I want to use the shape command to generate the parent child
relationship of customers and the services they have, and to do this I
have the following code:

tsql = "SHAPE {SELECT * from customers" & _
swhere & _
" } APPEND ({SELECT Service_name, customerid from
services s ,customer_services c where" & _
" s.service_id = c.service_id}" & _
" AS oRSServices" & _
" RELATE customerid TO customerid)"
sconnect = scCONNECT_SHAPE

It works find, BUT I do not want the customerid of the child to appear
again in the recordset, but i must select it in the columns in order
to get the Relate to work correctly....

What can I do to remove the customerid column from the child
recordset?


Thanks in advance!!