3 Replies Latest reply on May 12, 2011 8:18 AM by philmodjunk

    Multi Point Record Selection

    BradenDouglass

      Title

      Multi Point Record Selection

      Post

      Ok all, I originally thought this was an easy solution; however, I am running into an issue. The users want to be able to select a Customer by either their name (currently a cascading drop down list) AND by a separate account number. I have added the the account number into the relationship graph much like the first selection cascading dd field. However this does not seem to work. Anyone have any ideas? Thank you so much for your help.

        • 1. Re: Multi Point Record Selection
          philmodjunk

          I think you need to describe what you need and what you've tried in a bit more detail.

          What is supposed to happen when they select a name in the drop down? (A script performs a find, records appear in a portal or in blank fields on the current layout, or?)

          Exactly what relationships did you define for the two drop downs that didn't work for you?

          • 2. Re: Multi Point Record Selection
            BradenDouglass

            Sorry, yeah my original explanation was fairly spartan. The cascading drop down list uses takes a primary key from the company and passes it to the second table as company name (the first selection). The same company primary key then is passed into the customer field(second selection in the cascading dropdown). A table occurance of the customer table then gets passed into the 2nd table for selection.

            I originally attempted to use the acctNumber from the company table and just pipe it into the selection field from table 2. This didn't work. Then I took a table occurance of the company table and pipe it back into the 2nd table. 

            The dropdown list is just used to drill through company/contacts. Ideally you would want both the acct number and the company name to do the same thing. If I select the company Name drop down it will fill in the acct number and allow me to select relevant contacts. This would do the same if I selected the acct number, the name would be selected and I could select a certain contact.

            • 3. Re: Multi Point Record Selection
              philmodjunk

              Sorry, but I still have questions about what you are trying to do and how your system is designed.

              Is this to create a new record or to find existing records?

              What tables do you have and how have you related them?

              Can you list the relationships involved in this format?

              TableName::KeyField = TableName::Keyfield