2 lookup fields messing in a view
Hi
I've go a "User" database with Name, Last Name, .... + a field "Position"={Underwriter OR Assistant}
I've got a "Submission" database where I assign an UnderWriter and an Assistant
(I'm using criteria in the lookup field to get only underwriter in the first one and Assistant in the second.)
It work great but when I'm in the "submission view,
the assistant field mess with my underwitter field:
- when I search in the assistant field, it search in the Underwriter field
- when I add a criteria to the view it doesn't work
- when I use this criteria in an url it doesn't work
What have I done wrong?
- Should I use two different DB for Underwriter and Assistant
- Should I use one field with Multiple select?
Thanks for your help