Create field with multiple event date history

[Richard]

I have a database of just over 1,000 members for my karate club and I’m trying to figure out how to create a “grading history” field where I can select a members rank and enter the date that they were promoted so that I can track their history and progress better. Pick list only allows me create a list of ranks I want (9th-1st kyu then 1st-5th Dan) but I can’t allocate a date to each rank. This needs to be different for each member record obviously. Do I need to create a separate field for each rank/date or is there a way of making a drop down list for the rank and just enter the dates as they progress?

Any help would be much appreciated.

Thanks

[Brendan]

Hi Richard,

This sounds like the job of a Link to Form field.

You would have your Members form, and a new form to hold the Grading History fields. Then in your Members form, add a Link to Form field which links to the Grading History form.

Then for every member, you can add one or more Grading History records to it.

Take a look at the Relationships section in the online user manual here:

https://www.tapforms.com/help-mac/5/en/topic/relationships

[Mike Schwartz]

Why not use a Table Field called “Grading History” and define two fields for the table, Rank and Date. The Rank field within the table can use a pick list.

— Mike

[Richard]

Thanks Brendan.

That works perfectly.

[Brendan]

Mike, there’s no such field type called Table :) (not yet anyway).

[Mike Schwartz]

Must have dreamt it. Sorry. :-(

[Author]

Posts