2 Replies Latest reply on Apr 9, 2009 12:23 PM by synergy46

    Field Lookup ???

    synergy46

      Title

      Field Lookup ???

      Post

      I have a typical 'many-to-many' relationship established:

       

      Members Table:

      memberID.pk

      lastname

      firstname

      etc.

       

      MemberAcct Table:  (Join table)

      MemberID.FK

      AcctNumber

       

      Accounts Table:

      AcctNumber

      Description

      Catgegory

      etc...

       

      The relationships are set and this works as expected.

       

      Question:  "Can I setup a DROPDOWN field in a portal that would show all the account numbers and their descriptions?

       

      I know I can do it with Value Lists but can I get the same affect with some kind of lookup?

       

      Thanks

       

       

        • 1. Re: Field Lookup ???
          philmodjunk
            

           

          Question:  "Can I setup a DROPDOWN field in a portal that would show all the account numbers and their descriptions?

          Yes. Define a value list and specify both acctNumber and Description from the Accounts table as a two column value list. You can format fields in portals just like you would in any other part of a layout.

           

          I know I can do it with Value Lists but can I get the same affect with some kind of lookup?

          What?? Describe what you have in mind here. Since you can do it with a value list, why would you need something else that does the same thing?

           

          • 2. Re: Field Lookup ???
            synergy46
               Kewl!  I totally overlooked the ability to designate table fields in value lists.  Kudos!