Merging Data into a field

[#1]

Hello everyone,

Is it possible to take two text fields and map them together

e.g. Item + product = itemproduct so it produces a unique field to map against in another table (which i've created separately)

these are in two separate tables

audicar

auditruck

audilorry

bmwcar

bmwtruck

bmwlorry

fordcar

fordtruck

fordlorry

so every time audi and car appear it is audicar

Thank you for your time

[#2]

try:

item&product as itemproduct

[#3]

Thanks for your reply. Where would I put this syntax? Will this work for two different tables?

Table 1 has the item in and table 2 has the product in.

[#4]

I guess not. It's working only these field in 1 table. So i think you should join these 2 tables.

Give us some example or something.

[#5]

one table has departments and amounts, and the other has industry codes in and i've created this table below. what I need is department and industry codes so I can map it to other tables as a unique identifier. at the moment there is no unique id that says FRT and CAR= FRT commercial

The idea is to select FRT commercial and just get a total of all the FRT commercial. problem is that when I select FRT commercial now I get the total of FRT and any industry that has aviation car cater charity in it (i.e. a total of everything)

ID	Department	Industry Code	Industry Description	New Department
FRTAVIATION	FRT	AVIATION	Aviation - NOT OPERATORS	FRT Commercial
FRTCAR	FRT	CAR	Car / Motor-related Co s	FRT Commercial
FRTCATER	FRT	CATER	Catering	FRT Commercial
FRTCHARITY	FRT	CHARITY	Charities and foundations	FRT Government
FRTTCAVIATION	FRTTC	AVIATION	Aviation - NOT OPERATORS	FRT Time Critical
FRTTCCAR	FRTTC	CAR	Car / Motor-related Co s	FRT Time Critical
FRTTCCATER	FRTTC	CATER	Catering	FRT Time Critical
FRTTCCHARITY	FRTTC	CHARITY	Charities and foundations	FRT Time Critical
CADAVIATION	CAD	AVIATION	Aviation - NOT OPERATORS	CJ Other
CADCAR	CAD	CAR	Car / Motor-related Co s	CJ Other
CADCATER	CAD	CATER	Catering	CJ Other
CADCHARITY	CAD	CHARITY	Charities and foundations	CJ Other
EADAVIATION	EAD	AVIATION	Aviation - NOT OPERATORS	PJ ADHOC
EADCAR	EAD	CAR	Car / Motor-related Co s	PJ ADHOC
EADCATER	EAD	CATER	Catering	PJ ADHOC
EADCHARITY	EAD	CHARITY	Charities and foundations	PJ ADHOC