Help

Add a date to linked record

1499 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Troop_300_Thund
4 - Data Explorer
4 - Data Explorer

I have a table of boy scouts and a table of merit badges. I can easily add multiple merit badges to each scout, but I want a “date earned” associated for each merit badge when each boy earns it.

1 Reply 1
Ivan_Carlson
7 - App Architect
7 - App Architect

Sounds like you would need a join, junction or linking table to store the information using a many-to-many relationship, a link between the Scouts table and Badges table. A scout can have many badges, and a badge can be earned by many scouts. The Merits linking table could have a scout field linking back to Scouts, and a badge field linking back to Badges, and a DateEarned field that stores the date the badge was earned by the scout.