gathering info from multiple previous records?

[stann]

Hello

I have 10 fields called "ago1, ago2,ago3,ago4, ago5, ago6, ago7, ago8, ago9,ago10"

I would like the information in each of those fields to be THAT number of records prior's information.

In other words- if I have 11 records and the content of those records sequentially was

T45,A88, D11, J10, J9, A44, B22, B16, C43, E55, A12

Then Record 11 would contain A12

and on that record there would be a column of fields and they would be as follows

ago1 = E55

ago2 = C43

ago3 = B16

ago4 = B22

ago5 = A44

ago6 = J9

ago7 = J10

ago8 = D11

ago9 = A88

ago10 = T45

Could some of you give me ideas on how to do this efficiently.

I would like to be able to click on that field and go to that information automatically, Which I can do.

I just don't know how to keep the information in order like I am asking above.

Thanks

STANN

[Ugo DI LUCA]

Hi Stann,

"Then Record 11 would contain A12..."

where ? In what field ?

I have the feeling ago1 to 10 will not lead you much far, and that there must be a more solid and reliable solution.

But then It's not very clear what your goal is exactly.

[stann]

yes Record 11 would contain A12 in Another field called "Laneassignment"

I have block clerks at an auto auction . I need to be able to show them the last 10 or 20 lane assignments as they proceed from record to record. If they have missed information on any of the previous records, then a button that would take them to the record holdin those contents would be the fastest and most efficient way to get them back to that record for correction because this is live during an auction and every minute counts.

[Oldfogey]

For Version 6.

Set up a Serial field.

Define a series of fields - BackSerN = Serial - N

Define a series of relationships - BackSerN => Serial

Then you can pick up LaneAssignment from each of the previous N records.

For Version 7.

I think you can do this with just one relationship. Am I right? (Haven't played enough yet.)