3 Replies Latest reply on Nov 19, 2009 1:07 PM by philmodjunk

    Relation with date fields

    PerBäckman

      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

       

       

        • 1. Re: Relation with date fields
          philmodjunk
            

          Are the date fields of type "date" or type "text"?

           

          The relationship you describe should work if the fields are of type date. If they are type text, they will not work the way you want.

          • 2. Re: Relation with date fields
            PerBäckman
              

            Yeah. Thats what I think to.

            The goal is to wiew the lines with past dates. So I I add the value for a cirtain project and a date, I would see the lines that has past dates only. The future dates I would not se.

            I have tried this in a compleetly new file.

            Can I send files here?

            Thanks

             

            • 3. Re: Relation with date fields
              philmodjunk
                

              No, but you can upload the file to a file sharing site and post the link here.

               

              If you are sure that the fields are of type date. Try posting a more detailed description of what you are trying to do and how it doesn't work.

               

              For example: Are you trying to display the records in a portal? If so, how have you set up the portal? What do you see in the portal?