Lookups and Picklists

Comments

5 comments

  • Avatar
    Jonathan Hsu

    Hi Karl, do you mean you're having trouble with doing an option list that it segmented based on a smart table search?

    0
    Comment actions Permalink
  • Avatar
    Karl Simms

    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.

    0
    Comment actions Permalink
  • Avatar
    Karl Simms

    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 :) 

    0
    Comment actions Permalink
  • Avatar
    Jonathan Hsu

    Admittedly you confused me a bit there Karl, but I'm glad you got things working. Keep pushing the limits, love seeing the solutions you come up with!

    0
    Comment actions Permalink
  • Avatar
    Karl Simms

    Sorry Jonathan im not great at explaining things lol. 

    Theres always a work around at some point just finding it.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk