I have 6 golfers per team and I want the 4 lowest scores from each team to be a total team score, but I don't want to click any buttons, just enter each players hole scores and once the total 9 hole score is calculated for all six golfers it ranks them. I understand that there may be scores with the same value (40,36,40,42,52,43) end result (36,40,40,42= 158).

I have 6 golfers per team and I want the 4 lowest scores from each team to be a total team score, but I don't want to click any buttons, just enter each players hole scores and once the total 9 hole score is calculated for all six golfers it ranks them. I understand that there may be scores with the same value (40,36,40,42,52,43) end result (36,40,40,42= 158).

I have 6 golfers per team and I want the 4 lowest scores from each team to be a total team score, but I don't want to click any buttons, just enter each players hole scores and once the total 9 hole score is calculated for all six golfers it ranks them. I understand that there may be scores with the same value (40,36,40,42,52,43) end result (36,40,40,42= 158).

Make a caluclated field = Score & " " & GolferID, were GolerID is an unique serial number. Use this field to make a related value list. Then use ValueListItems to make a list of the golfer scores & Id's Pick the top four scores off the list.

Make a caluclated field = Score & " " & GolferID, were GolerID is an unique serial number. Use this field to make a related value list. Then use ValueListItems to make a list of the golfer scores & Id's Pick the top four scores off the list.

Make a caluclated field = Score & " " & GolferID, were GolerID is an unique serial number. Use this field to make a related value list. Then use ValueListItems to make a list of the golfer scores & Id's Pick the top four scores off the list.

Thanks so much, is there anywhere I can find an example close to this, because I'm a beginner and this makes sense but I'm not sure how to go about this.

Thanks so much, is there anywhere I can find an example close to this, because I'm a beginner and this makes sense but I'm not sure how to go about this.

Thanks so much, is there anywhere I can find an example close to this, because I'm a beginner and this makes sense but I'm not sure how to go about this.

What do you have so far? Can you post a sample of your database? I could make a sample but it would be easier to build on what you have.

What do you have so far? Can you post a sample of your database? I could make a sample but it would be easier to build on what you have.

What do you have so far? Can you post a sample of your database? I could make a sample but it would be easier to build on what you have.

Since I haven't hear from you I put together a sample file.

Since I haven't hear from you I put together a sample file.

Since I haven't hear from you I put together a sample file.

I hope this makes sense to you. Again thanks.

I hope this makes sense to you. Again thanks.

I hope this makes sense to you. Again thanks.

Picture1.pdf

I have modified my file to display like your example.

I have modified my file to display like your example.

I have modified my file to display like your example.

He is my file, the one you made looks great and works great, but I would like to print this off when the golf meets are done without all of the extra fields. Thanks much

He is my file, the one you made looks great and works great, but I would like to print this off when the golf meets are done without all of the extra fields. Thanks much

He is my file, the one you made looks great and works great, but I would like to print this off when the golf meets are done without all of the extra fields. Thanks much

Did our files pass each other? I think the last one I sent is almost what you want.

Did our files pass each other? I think the last one I sent is almost what you want.

Did our files pass each other? I think the last one I sent is almost what you want.

yes the files must have passed, I will check it out.

yes the files must have passed, I will check it out.

yes the files must have passed, I will check it out.

It's almost perfect. The new one you sent me doesn't have a team score. Thanks Ralph.

How can you enter all of that data in such a short time.

It's almost perfect. The new one you sent me doesn't have a team score. Thanks Ralph.

How can you enter all of that data in such a short time.

It's almost perfect. The new one you sent me doesn't have a team score. Thanks Ralph.

How can you enter all of that data in such a short time.

It did when it left here. On the layout Score Card it is under the center 2 columns. I didn't think that 9s fast. Once I had one portal laid out I used duplicate to make the next 5 and then changed the starting portal row in each.

It did when it left here. On the layout Score Card it is under the center 2 columns. I didn't think that 9s fast. Once I had one portal laid out I used duplicate to make the next 5 and then changed the starting portal row in each.

It did when it left here. On the layout Score Card it is under the center 2 columns. I didn't think that 9s fast. Once I had one portal laid out I used duplicate to make the next 5 and then changed the starting portal row in each.

I cant get the team score to work, I tried to change scores, to no sucess.

I cant get the team score to work, I tried to change scores, to no sucess.

I cant get the team score to work, I tried to change scores, to no sucess.

Try clicking on the team score field after updating. You may also want to look at using a script with the Refresh Window Flush Cached join. You can use the Event Script Plug-in to automate this.

Try clicking on the team score field after updating. You may also want to look at using a script with the Refresh Window Flush Cached join. You can use the Event Script Plug-in to automate this.

Try clicking on the team score field after updating. You may also want to look at using a script with the Refresh Window Flush Cached join. You can use the Event Script Plug-in to automate this.

Hi Ralph

I've been going through your post here and trying to apply it to a similar database where I want to get the top 2 highest marks from 4 marks. I have a Student and Assignment Table related via the Student ID (one to many).

The part I can't get to work is how do I get the ValueList to be in Descending Order? from the sample files you've made I can't see any sorting going on, it looks as if the scores were entered from lowest to highest to get them in the correct order in the ValueList field. Is this so? If not how can I get the ValueList field to be ordered so the 2 highest marks are on the two top lines?

Thanks, Matt

Hi Ralph

flag that I just figured out the Value List does the sorting ascending and theres no way to change that so I've used your suggestion above with the ValueCount function to figure out the bottom entry (highest mark) and ValueCount-1 to get the 2nd bottom (2nd highest mark).

I am also interested in this...is the sample file available anywhere?