I have two related tables, one is a stamp id table, which contains my list of codes related to our membership stamps. The other is a stamp transaction table.
I use this list above on (stamp quarters table) another table (stamp transactions) which is where the user enter the appropriate information.
The drop down list on the stamp sale record has a drop down list which is populated from the above table.
I am trying to figure out a solution to have the drop down list only show stamp id codes 12 (2018-4) thru 16 (2019-4) only on the input form below to keep the user entering the stamp quarter id code properly. There has been numerous issues with persons not paying attention and entering the proper stamp quarter id.
I am not sure if the quarter stamps id list I created is even the most efficient but it is what I am working with now.