September 24, 200520 yr 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
September 24, 200520 yr 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.
September 24, 200520 yr Author alright, i'll see how i can incorporate this into my project. once again, fenton, you save the day!
Create an account or sign in to comment