Thanks Helen



Small typo messing me around:



qrAnimal



SELECT * FROM ANIMAL ORDER BY...



qrLOCATION

SELECT * FROM LOCATION



KEYLINKS: LOCATION = qrANIMAL.ANIMALLOCATION

KEYSOURCE: dsANIMAL

KEYDESCLINKS: LOCATION=ANIMALLOCATION

KEYSEEKIN := True;



PS the field is called ANIMALLOCATION, and I had it set up as
ANIMAL.LOCATION, instead of ANIMAL.ANIMALLOCATION,

Thus the key relation was not correct, and didn't want to work.



Well, I sure learnt a lot, but my heads still buzzing!



Many thanks HELEN



I see I can do this with Foreign Keys, I read the chapter in your book, but
will leave that for another day!



Adrian





[Non-text portions of this message have been removed]