General

Re: Getting data from same record

jlgpsidev2010 — Thu, 29 Sep 2016 23:24:32 GMT

Thanks Hillary. I will give that a try and report back in the next day. Appreciate your response.

Re: Getting data from same record

Hilary Stoupa — Wed, 28 Sep 2016 15:08:40 GMT

I'd think it would be - create another data connection to the list, set the correct query field to the player ID, run the query, and display the data from the data fields in the secondary data connection on the form?

Re: Getting data from same record

jlgpsidev2010 — Tue, 27 Sep 2016 20:36:58 GMT

Hillary, this worked perfectly! Thank you so much!!

I have one more issue that is a little more complicated. Is it possible in a list form to do the following?

PlayerID 101 pays for 8 players. In his record only, I would like to show a list of all of the players names that he paid for.

Is that possible?

Re: Getting data from same record

Hilary Stoupa — Tue, 27 Sep 2016 19:35:59 GMT

I added rules to the paidby field to set the query field in Golf Names, run the query, and set the Paid By Name. Save the file locally, right click and select design and then preview to see if this does what you need.

Re: Getting data from same record

jlgpsidev2010 — Mon, 26 Sep 2016 16:12:18 GMT

So, just to explain this image. I am trying to get the "paid by name" column to display "Ascher, David" because his playerid=101 and he paid for all of these people and the "paid for" column for Ascher, David to display all of the names of the people that he paid for. Is this possible?

Re: Getting data from same record

jlgpsidev2010 — Mon, 26 Sep 2016 15:32:59 GMT

Hillary, also here are the relevant columns in the list.

Re: Getting data from same record

jlgpsidev2010 — Mon, 26 Sep 2016 15:31:12 GMT

Hi Hillary, what I am trying to accomplish in this form is to complete Paid By Name by using the Paid By column. So if "Paid By" is equal to 101 (which is the payer's "Player ID"), then I would like to query the list to find the "full name" for "Paid By" and populate the name in "Paid By Name". Is this possible. These are all just text fields.

Re: Getting data from same record

Hilary Stoupa — Wed, 31 Aug 2016 00:53:05 GMT

Can you attach a copy of your form under the Options tab in a reply? I'm not really sure what you currently have in place here. :)

Getting data from same record

jlgpsidev2010 — Mon, 29 Aug 2016 13:12:24 GMT

I think that I may be overthinking this. I am creating a form for golf registration. If someone pays for someone else during online registration, it will add the GOLF ID of the person who paid to the record of the person that they paid for. So golfer 'David Smith' has Golf ID "001" pays for golfer 'John Jones', it shows in column 'Paid By' "001". I would like to display in a separate column called "Paid By Name", "David Smith"

Golf ID Golfer Paid By Paid For Paid By Name

001 David Smith 002

002 John Jones 001 David Smith

How can I get this data? What would formula in Paid by Name be to get "David Smith" in that "Paid By Name" field?

Thanks for any assistance.

Jamie