AnsweredAssumed Answered

Relation with date fields

Question asked by PerBäckman on Nov 19, 2009
Latest reply on Nov 19, 2009 by philmodjunk

Title

Relation with date fields

Post

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:

ProjectNr

Delivery date

Description and

Value

 

The serch table serchform.fp7 have:

ProjectNr

Date

 

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.

Please help

 

 

Outcomes