Can someone explain how to use reference fields within a data query or provide examples of their use, please.
I have two look up collections, lstCommittee (fields Name and cKey) and lstJobs9 fields (Position and pKey) that are used in a Jobs collection that contains:
Member | cKey | pKey
fred | AC | T
dave | AC | S
mike | LC | S
I’d like to produce a results set that contains {member, Position} where cKey = “AC” say.
I’d be happy going about this in SQL with joined tables etc, but I’m afraid I’m struggling with the documentation on how to do this in Corvid. I’ve tried using “Include” in a query, but I’ve failed to specify a correct entry for the .EQ statement. Also, how to include foreign fields (lstJobs.Position ) in the end result set.
Any pointers would be gratefully received.