1 Reply Latest reply on Sep 5, 2012 11:30 AM by philmodjunk

    what am i doing wrong with look up?

    Sketter

      Title

      what am i doing wrong with look up?

      Post

      Hi,

      So I'm trying to get a look up to work.
      I have a database of customers, that give in regular payments.  Each customers also has a TOH number.

      We create daily check receipts in excel however i wanted to create a better database for tracking payments and so on.

      So on a daily check receipt i need the TOH number to show up, i assume i can use a lookup, but it isn't working.

       

      I have attached a link to a dumbed down test database to find out how to get this lookup to work right.

      sketter.net/demo/test_lookup.fmp12

      Hope someone can help.

       

      Thanks!

        • 1. Re: what am i doing wrong with look up?
          philmodjunk

          You shouldn't need a looked up value setting but it should work if you have a valid relationship between two tables. That requires that the right match fields be linked in the relationship and the right matching values be entered into those fields. A looked up value setting will not change what is shown on records created before you added this field option but would work for any new receipt records you create provided the relationship details are correct.

          In your case, the COS IDFK is blank in the Payment table so there then is no valid link from payments to test lookup.

          Once you have a valid relationship working, you can just add the TOH field from test lookup to the portal row and it should display the current TOH value without any need for a TOHID field in payments.