Field content is from another field but filtered?
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!!