Get(RecordID)

[ron G]

I have 2 tables:

Members

Dues

Members <-->> Dues

A layout based on Members has Members data on the top 1/2 and DUES::portal on the bottom 1/2.

I am trying to determine if using GET(RECORDID) return me to a specific portal row that, after it is sorted gets rearranged according to sort order. For Example:

2000

2001

2010

1999

Let's say I just entered 2002 at the bottom, blank row in the portal. I am trying to identify the 2002 row, then sort the column and then find the 2002 row again.

I have written a script using Get(RecordID)but after it is run, it seems to find the recordID of MEMBERS (Not DUES???) and the go to Field takes me to the top row of the portal.

Got any ideas? Am I 'misusing' the get(recordID)? Is there a better function? :huh: