AnsweredAssumed Answered

Field content is from another field but filtered?

Question asked by jackmac on Jan 20, 2013
Latest reply on Jan 21, 2013 by philmodjunk

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

Outcomes