1 Reply Latest reply on Jan 21, 2013 9:42 AM by philmodjunk

    Field content is from another field but filtered?

    jackmac

      Title

      Field content is from another field but filtered?

      Post

           Hi all,

           Been banging my head all day on this and need help. I know it's obvious but am stuck...

           I have a table (workflow) which has contents with multiple fields. One field has the company name, another has the relationship (staff, customer or supplier). I have another table (Products) which products in it.  I want to put a supplier field in there so people can choose from a drop-down list of suppliers we deal with.

           Obviously this means:

           the 'supplier' field in the 'Products' table looks at the 'Workflow' table. It then needs to say:

           if workflow::relationship = 'Supplier', workflow::'companyname'

           On paper - easy, to get it working.. aaarrgghhh!!

           Helpl!!

           Thanks