1 Reply Latest reply on Sep 2, 2011 8:07 AM by philmodjunk

    Date fields stays same on All records for same CustomerID !

    AdrianWilliams

      Title

      Date fields stays same on All records for same CustomerID !

      Post

      Contacts file  --is related to--> Products file.
      I enter CustomerID in Products file to bring the contact info across. That's fine.

      In Products file I've added 12 Date fields to a Layout. But every time I create a New Record for the same Customer, ALL DATE FIELDS are the same as those contained in the first record for that Customer!

      After 4 hours struggling, I'm confused. Any idea how can I have different Dates on each record?

      Thanks,
      Adrian

        • 1. Re: Date fields stays same on All records for same CustomerID !
          philmodjunk

          In Products file I've added 12 Date fields to a Layout.

          But in what Table are they defined? If you deinfed these in Contacts, you will see the same dat every time you link a given products record to that customer, you'll see the same dates. That's one very likely explanation here. (A given Layout can have fields from both tables here.)

          You've described this in terms of two files. Do you really have two files or just one file with two tables?