What field type to record a set of receipt numbers & dates?

Hi
I am looking for suggestions as to the best way to incorporate fields that, for each membership year (each year being defined as a selection from a multiple check box), records a receipt number and (separately if need be) receipt date.

So something like
Option 1
Value Label
123 2015
234 2016
456 2017
Option 2
Value Label
2015-01-01 2015
2015-02-02 2016
2015-03-03 2017

Or better still
Option 3
Value Value Label
123 2015-01-01 2015
234 2016-02-02 2016
456 2017-03-03 2017

I could do it via a separate table linked to comprofiler but I am not sure that is the 'safest' way forward. It would sem better to include it in comprofiler so that I can use cb code to maintain that data.

Or can I, using options 1 & 2, write code to change the value if I fill it with dummy values on field creation,

any suggestions gratefully received.

Regards
Nick

You'd need to likely use a CB Query Field and its Query Select fieldtype in combination of a separate database table. I've no idea what's creating or managing receipts, but I assume the dropdown values need to be different per user and only way to do that is a separate table that you query for.

Hi Kyle

ah hah! that makes sense. If I can tie an external table to the cb tables via CB Query Field that should overcome my concern about the integrity risks of using external tables.

Thanks - I will give that a try.

Regards

Nick