Hi All,

I'm at the end of my tether here where i've been trying to get something (that would take about 10 seconds to do in any programming language) to work in Crystal. And im at the stage where im ready to chuck the computer out of the window.

All I want to do is something like:

SELECT "Name" FROM "Clients" WHERE "Clients.ID" = "Quotes.Contact_ID"

and it seems like something *that* simple is too complex for Crystal to handle, which has to be false.

Anyone have any ideas?

Thanks

Hi DBlank,

Thanks for replying.

I dont think i've explained myself clearly enough due to the heat of the moment.etc.

To be clear:
The linking is done and correct.etc however I need to perform two seperate lookups to the same database table in order to retrieve the information required to get the right data into the report.

Essentially, the client table in this circumstance holds both the company information as a row as well as a row for the primary contact within the table. (I didn't design the database, its from a CRM package I should add).

So the db will have a schema as follows:

ID    Name             CID
1     Company X     3
2     John Doe        3

So in the Report it will have something like:

Contact: John Doe
Company: Company X
Address: ....

Now as the report gets generated through the CRM - I thought the best way to deal with the issue was to use a SQL query to get the correct details (which i've done countless times  in php / c / asp.net and so on for various other projects).

So literally, it just needs to be something as simple as the sudo code I wrote in my first post (SELECT "Name" FROM "Clients" WHERE "Clients.ID" = "Quotes.Contact_ID"), But Crystal just wont play ball, and whilst recognises commands like 'SELECT' doesnt appear to understand anything else - making me rip my hair out.

Any ideas?

Glad you go that fixed. You should have been able to write your SQL query in as a COMMAND in the DB Expert though.