Lookups and Picklists
i was wondering if anyone else has come across this before?
Ive never really noticed it a great deal untill now, basically.
I have numerous forms that ive built up over the years, some basic, some quite advanced.
One thing ive noticed is how dependant ive come of picklists.
I love the new lookup feature within text the search is great, however on some of the projects im doing, im finding it rather difficult to hide other fields based on whats entered into the lookup.
(conditional: lookupdcn=="Exact Text") i really miss the picklist lookups, is there a way i can get these back? i know i can trick iform into setting a label as required (good for visible verifications and validation)
Mr Jonathan Hope your well sir.
Kind of, ive never been any very good at explaining things i do apologise.
I think im explaining it more complicated than it is lol.
So, before the new lookup feature was implemented, we used to be able to create a picklist and assign that picklist a lookup.
From there i could set a conditional on a lookup field, so for an example picklistdcn==0.
What i could also do is pass the data from the original picklist to another picklist (that would preform the same lookup) and it would do that lookup, what im finding with the new one is, the user has to physically go into the list to select an item.
Does that make a bit more sense or am i just gibbering on lol.
Ive sorted it :)
Basically what i did was on the lookup table (the database) i created a new field, called it index.
Changed the records to show by Index Value , 00,01,02,03,04,05 etc etc through the options.
then on the main form, i put in a new field that looked up the new index field, its a bit of extra work but works just as well :)
Please sign in to leave a comment.