Another problem that I cannot get to work?
Layout for Church. I have a field (type) in Membership table and I have lookup (Donation Name) in Donations table that finds the Member name. When I do a lookup from Donations for LastFirstName I also want to copy data from the "Type" field from "Membership" into "Donations, Type" field. I want to know if the Member is "Active" or "Inactive".
I cannot find a way to do this? I have tried many things but still not working. The relationships are defined for "Type" in both tables.