Comparing fields to produce another result

[zircom]

I am having trouble getting a result from 2 database views.

IV00102.LOCNCODE (this view is Inventory) holds a field with stock location and Qty's ie: ENG12G

SVC00100.LOCNCODE (this view is Service) holds the same info and in the same database view is SVC00100.NAME which hold the actual name ie: Bill Smith

I want to dispaly the actual name in a report on stock holdings and who has them, without having to keep refering to location codes to see who the person is.

Any help please

 

[lbass]

Link the views on the location code, and then place the name field in the report.

-LB

 

[synapsevampire]

Assuming that this location code is in both views, join them by the location codes.

You're better served to post technical information than trying to decribe it:

Crystal version
Database/connectivity used
Example data (and field names)
Expected output

Crystal does not allow for 2 unlinked datasets to use the other as a lookup, so join them, or create a single view.

-k