Relation with date fields
Filemaker 10 in windows network with server 9
Hi, I try to relate some order-lines with a search record.
The table with order lines Lines.fp7 have:
The serch table serchform.fp7 have:
The relation has 2 criteria is like
Lines.fp7 ProjectNr=Searchform.fp7 ProjectNr
Lines.fp7 Delivery Date<Searchform.fp7 Date
This way I would have been anble to wiev all lines for a project earlier than a special date.
But when I add the date. It does not work.
The larger than or less than does not seem to work at all in relations.
All fields is indexed and has the same field type.