an easy one?

[crebma]

what's the easiest way to make a relational database that can work on OR instead of just AND??

ex:

am = am

OR pm = pm

is this possible?

thanks!

amber

[Fenton]

There is not an "Or" operator in relationships. But, if you exploit the "multi-line" nature of relationships you can usually get what you want. A mutli-line field, on either side of the relationship will give you all records that match EITHER of the lines.

This is done by creating a key separating the values with a carriage return, ¶ in the calculation.

[crebma]

alright, i'll see how i can incorporate this into my project. once again, fenton, you save the day!