Access field values from already loaded table

[#1]

Hi Team,

How can i access fields from the table that is already loaded in qv?

Actually, I have loaded my Master.xls file that contain only one column viz. City with city names in it.

After that, I am loading transaction records from other xl file.

For every transaction record, i want to check wheter City name in transaction record is appearing anywhere in my Master.xls?

How can i do that?

Pls Suggest!!

[#2]

Hi Arun,

load your CityField name twice in both tables like:

MasterData:

Load

CityName

CityName as CityNameMaster

....

Transaction:

Load

CityName

CityName as CityNameTrans

Now you can select possible or excluded values in the listboxes.

If you want only have transaction data for CityNames in your Master Date than use:

Transaction:

Load

CityName,

....

From ...

Where Exists (CityName);

as example.

Good luck!

Rainer