validate by Value List and more

Records in table Projects and table Expenses are in relationship
when the values in fields "projects name" are the same. I created a
Value List that contain all values from Field "projects name" in table
Projects. So can i make a drop down list in table Expenses that display
all values in field projects.

Now come the tricky part. I wish to make a validation via
calculation that include the values from the value list and the string
"not a part of any project". I could make a validation only by the value
list, but, but when I make reports, and have a subsummary that is sorted
by the projects field, it will not make the subsummary because the
projects field is empty. Is there any solution? I played with
ValueListItems and some other functions, but no success.

Regards
Tom

--
Pozdrav
Tomislav Car
.