Hi Kim,
So is your "Customer" table basically a subset of your "Club Members", or do you have "Customers" who aren't "Club Members"? Here's how you could handle each case:
If ALL your Customers are Club Members, then you just need to pull the related fields from the "Club Member" into your "Customer" table. You wouldn't need fields on the Customer because you would be pulling the related fields from the Club Member record. In the Customer-Club Member table relationship, add the look up fields of email, address, etc. (If someone is completely new, then they probably need to be entered first as a club member, then added as a Customer)
If you have some Customers who aren't Club members, then you would need a separate field, but could copy that info to those fields using an automation. For that you could set an automation that says when a Customer is created, you copy the related Club Member fields to the corresponding Customer fields.
I hope this helps.
------------------------------
Kim G
------------------------------
