Linking Problem

[mtownbound]

CR9
Oracle DB

I have two tables (Customer,Order) that both have the Customer Id column. Linked the Customer Id's in the datbase expert window. Customer is the primary table, but if I attempt to add a column from the Order table, I get the following:

Failed to Open Rowset
Details: 42s:column found in multiple tables

If I completely remove all links, I get the data I want but it's scanning ALL of both tables which takes an excruciating amount of time. So what am I missing with the link?


Thanks!!!!

Mtown

 

[synapsevampire]

I'd guess that's you're using the wrong type of connectivity, probably the Oracle supplied ODBC driver.

Also you don't state the version of Oracle, which of course might change the solution.

Please remember to post basic technical information.

Try using the Database->Set Datasource Location and switch to either Oracle native connectivity (you'll see it listed as Oracle Server), or use the Crystal supplied Oracle driver.

Also the type of joins (links) may cause some issues, you might try posting the Database->Show SQL Query if the above doesn't resolve.

-k

 

[mtownbound]

Thanks for the feedback.

It's Oracle 8.1.7.4 and it actually has Remedy 4.2 running on top of it and I'm using the Remedy supplied ODBC driver. The link is an inner join.

This has got to be a Remedy or Oracle issue because if I use Excel or Access tables I don't have any linking problems.

Thanks again.