Combo with the fields in more than one Table

[#1]

Hi Dear,

I have two table Table A and Table B, with primery key "Item Description".

I Need a combo in below manner.

Company&'-'&VVL&'-'&Port&'-'& [CAM Description] &'-'&Test_Unit_Type as First_Combo

Table A	Table B
Company	Item Description
VVL	CAM Description
Port
Item Description
Unit type

How to create this combo ?

[swuehl]

JOIN, MAP or LOOKUP your CAM Description to Table A.

[#3]

Thanks Swuehl,

but unfortunetly not working.

Any other way ?

[swuehl]

One of these methods should work, as far as I see.

Could you post your relevant script snippet (what you already tried) and some lines of sample data?

[#5]

Try Like Below:

First create the Mapping Table for [CAM Description]

MAP_CAM:

Mapping

LOAD [Item Description] ,

          [CAM Description]

From SoureQVD.qvd (qvd) ;

ITEM_DETAILS:

LOAD Company,

          VVL,

          Port,

          [Item Description],

          [Unit type],

          [CAM Description],

          Company&'-'&VVL&'-'&Port&'-'& [CAM Description] &'-'&[Unit type] as First_Combo

;

LOAD Company,

          VVL,

          Port,

          [Item Description],

          [Unit type],

          ApplyMap('MAP_CAM',  [Item Description] ,'ND') AS [CAM Description]

FROM SOURECQVD1.qvd (qvd) ;