Need relationship or is there easier way?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I have a table that includes all members of our organization.  There are 5 types of members.  I have another table called Registration where I input these members' information when they register for an event we hold.  There is a relationship between Member Names and Registration.  But now I need the Member Type to be a column in Registrations table too so I can sort them by type.  How do I copy the Member Type from the Member table to show up in the Registrations table too?
Photo of Mandi


  • 0 Points

Posted 3 years ago

  • 0
  • 1
No problem.  Edit the relationship where 1 member has Many Registrations and "Add Lookup Field" field on the right side of the relationship.