Linking table's 1

[feest]

Dear reader,

I have for example 2 table's
Table 1 with 1000 part numbers
Table 2 with 500 part numbers

I want to create two collumns near each other.
I want to see all 1000 and all 500 part numbers
There where is no part number i want to have een emty space or for example an "N"

table 1 table 2
part number 2001001 2001001
3110000 3110000
4500000 empty of "N"
5454545 5454545
6700050 empty or "N"


I hope my question is clear.

Regards, Jan Raaijmakers

 

[lbass]

Use a left join FROM table1 to table2. Then place the part numbers in the detail section. Not sure, but you might need to go to database->select distinct records.

-LB

 

[feest]

Dear reader,

On this way i get only the 500 part numbers.
Who has another idee.

Thanks, Jan Raaijmakers

 

[lbass]

Please check your join. A left join FROM table 1 (the table with 1000 part numbers) TO table 2, the one with 500, will result in 1000 part numbers displayed.

Also, for this to work correctly, you cannot have any selection criteria on table 2.

-LB

 

[feest]

Thanks LB, and a Happy 2006

The selection criteria on table 2 was the problem.

I need a criteria in table 2, is this possible in anyway?

Tanks
Regards, Jan Raaijmakers

 

[lbass]

Instead of using a selection criterion on table2, create a formula in the formula expert like, e.g.:

if isnull({table2.field}) or
{table2.field} <> "Your criterion" then 0 else {table.amt}

Then you would be able to insert a sum just on those records you would have otherwise selected.

It's a little hard to make a suggestion without knowing what criteria you are trying to apply...

-LB