Try:
SELECT Horse.ID, Horse.HorseName
FROM Horse INNER JOIN HorsesCurrentlyatDruids ON Horse.ID=HorsesCurrentlyatDruids.HorseID;
Cheers,
VIP
Windows 10 
Access 2010 32bit
Try:
SELECT Horse.ID, Horse.HorseName
FROM Horse INNER JOIN HorsesCurrentlyatDruids ON Horse.ID=HorsesCurrentlyatDruids.HorseID;
Cheers,
One Lookup table with Two needed values; how to use both
Posting Permissions
Reply With Quote