Is There A Way To Do Data Unions In A View
I have a main form of members (member_info). Some members have family memberships and the data for the other individuals is in a separate form called (household_members). household_members is linked to member_info via the record ID of member_info. The person in the member_info form is the "primary" member and the household members are "additional members".
There are times that I want to produce a report of all members (the "primary" member in the member_info form plus the "additional members" in the household_members form). In SQL terms this would be a union - the last name of each member (primary or additional) would be reported in the last name field, the first name of each member (primary or additional) would be reported in the first name field, the email address of each member (primary or additional) would be reported in the email address field, etc.
Is there a way to do this in Zoho?
J