Using 2 Databases at Once

[Center]

When I used dbaseII I always used 2 databases at once, easily, and it always worked. Haven't figured out how in dbase IV. For test made a database called oldfile with fields key and city, indexed it on key to old.ndx. Made a database called newfile with fields key and company, indexed it on key to new.ndx. Put peoples' names in key, same people in both, different order.
If I copy this file right out of my dbase IV manual it doesn't work. How should I rewrite the next to last line or any other errors.
SELECT 1
USE OLDFILE INDEX OLD ALIAS PRIMARY
SELECT 2
USE NEWFILE INDEX NEW ALIAS SECONDARY
SELECT PRIMARY
SET RELATION TO KEY INTO SECONDARY
DISP NEXT 5 KEY->KEY,CITY,COMPANY
*(ALSO HAVE TRIED WITH A FILENAME JUST AFTER THE 5)

 

[AlfredD]

The correct last line should be:
DISPLAY NEXT 5 PRIMARY->Key, PRIMARY->City, SECONDARY->Company
Because KEY-> is not a valid ALIAS-Name and Company is not in SELECT 1

Greetings AlfredD

 

[Center]

Thanks a million AlfredD. I had tried typing the line hundreds of ways but never got it right. Keep up the good work.