Linking a table from with columns from two separate Tables

[Spudnik]

Hi,

I am new to Crystal Reports and I am having difficulty linking to two Tables to a third table.

I want to link a column from Table 1 and a column from Table 2 to their counterparts in Table 3. (Link column A of Table 1 and column B of Table 2 to column A & column B of Table 3) Is this possible using Visual Linking or SQL.

Any help would be appreciated.

Thanks

 

[glauco]

Good Morning,

I don't see why you couldn't do it 'cause is quite simple the way you explain, are you using a very old version of crystal or check the data type of the columns. You are so clear that i know you're almost done with that problem, just try to check again.

 

[Spudnik]

Still having difficulty with this linking problem. The links from Table 1 & Table 2 are working independently of each other. I want the combination of column A of Table 1 + column B of Table 2 to link to columns A & B of Table 3 (Columns A & B make up the unique key). Can't seem to be able to do this using visual linking. Do I need to use SQL?

Any help appreciated.

Thanks

 

[LuRSH]

Hi Spudnik,

First of all I'm assuming you're using at least Crystal 8 (I myself never used early versions) and that you are REALLY new to Crystal (sorry if I underestimate you in my answer, no harm intended).

I'm not quite sure if I understand what you want:

A) Is something like?

{table1}.{fieldA} Concatenated with {table2}.{fieldb} =
{table3}.{fieldc}

If this is the case smart link (as far as I know) do not support this configuration. You gonna have to take the rust out of your SQL abilities.

b) Or is it more likely to:

{table1}.{fieldA} = {table3}.{fieldA} AND
{table2}.{fieldB} = {table3}.{fieldB}

If this is the case the smart linking is enough. But if you are having problems with the "automatic" auto link (confusing?) set this feature off and link the fields of each table by yourself. Just click Table A first field and "drag it" to the field you want to link to on Table 3 (until you see a underscore "_" underneath the destiny field). Repeat for Table 2.

Hope it helps

Luciano R. Humberto
IT Specialist - Support I
The Ryan Companies