Another Pick From problem

Mark HHP

I am in the BSV AgencyClient. When I run this process:

PICK FROM FindClients

(FindClients query = FIND Clients WHERE Clients IN AgencyClient.PrincipalClients)

CREATE Quote WITH Quote.AgencyClient=AgencyClient, Quote.Client=ThisAgencyClient.PrincipalClients, Quote.QuoteStatus='Draft', Quote.Consultant=LoggedInConsultant

But no matter which one I pick, it always takes a certain client and inserts it.

In a previous BSV I was using a similar thing but without the query and that seemed to work ok. Any ideas what could be going wrong?

Rennur

FindClients query = FIND Clients WHERE Clients IN AgencyClient.PrincipalClients

The PICK FROM will place the 1 selected Clients in context.

Then try:

CREATE Quote WITH Quote.AgencyClient=AgencyClient, Quote.Client=ThisClients, Quote.QuoteStatus='Draft', Quote.Consultant=LoggedInConsultant

Cheers

Mark HHP

Aw man, you're magic.

The combination of deadline, lack of sleep, illness and other stresses has made me blind to simple errors.