How to select all that apply at the data entr...

(Tyson Carmichael (FlyTy)) #1

How to select all that apply at the data entry screen

Hey Team,

I have a table of accomplishments. It has a 1 to many relationship with the skills table. That is, 1 accomplishment can demonstrate many skills.

How do I present the skills field

as a select all that apply on the data entry screen for users? So after an accomplishment is selected, the list of skills appears and the user just taps on each skill that applies to that one accomplishment record.

Thanks

(Syed Faheemuddin) #2

You can choose column type as EnumList and use SELECT statement in ‘Valid if’ to get appropriate skills