Hi:
I have an interesting problem (I think). I have a set made up of 1-1-1 for three files (event - athlete - performance). I have a browse on a form that lists an athlete, the event he participates in and the performance. Thus, one athlete may be listed from 1-4+ times in the browse credited with performances marks in different events (100, 200, etc). Although listed multiple times, the same record# is listed for the athlete each time he appears on the browse.
Here is my problem. If I try to create a Zoom to Record using the athlete id#, Alpha is unable to go to the record I have focus on. Thus, if John Brown is listed in the 100 meters with a time of 10.67 and is also listed in for the 200 meters with a time of 21.84, and I double click on the 100 meter listing within the browse, the Zoom to Record fails to open the dialog form for this record. It selects another record (although in a few rare cases, it does select the right record). If I try using the event id# as my focus, I get "No records in query.
I hope I have provided a clear picture for you to follow. Is there a way to work around this and use the on row double click operation to open the dialog form for the record I have as focus? I tried using Action Scripting and "Open Form/Browse Layout", but that brought me the same results when I used the "Records that Match the value" filter.
Thanks,
Pete Schuder
I have an interesting problem (I think). I have a set made up of 1-1-1 for three files (event - athlete - performance). I have a browse on a form that lists an athlete, the event he participates in and the performance. Thus, one athlete may be listed from 1-4+ times in the browse credited with performances marks in different events (100, 200, etc). Although listed multiple times, the same record# is listed for the athlete each time he appears on the browse.
Here is my problem. If I try to create a Zoom to Record using the athlete id#, Alpha is unable to go to the record I have focus on. Thus, if John Brown is listed in the 100 meters with a time of 10.67 and is also listed in for the 200 meters with a time of 21.84, and I double click on the 100 meter listing within the browse, the Zoom to Record fails to open the dialog form for this record. It selects another record (although in a few rare cases, it does select the right record). If I try using the event id# as my focus, I get "No records in query.
I hope I have provided a clear picture for you to follow. Is there a way to work around this and use the on row double click operation to open the dialog form for the record I have as focus? I tried using Action Scripting and "Open Form/Browse Layout", but that brought me the same results when I used the "Records that Match the value" filter.
Thanks,
Pete Schuder
Comment