dennismoorejr

Value List Masking Possible?

Discussion created by dennismoorejr on Jan 24, 2019
Latest reply on Feb 11, 2019 by onefish

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.

 

Screen Shot 2019-01-24 at 5.25.25 PM.png

 

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.

Quarters Table Fields.png

QUarter Tables Field Calc.png

Quarters ID FIeld Info.png

Qurter ID Value List.png

Quarter ID Value List 2.png

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.

 

Stamps Sale Form.png

 

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.

 

Thanks

 

Dennis

Outcomes