I have a portal that is from another table that has ranges and prices for miles... They are linked together by the parents ID and both have recordID..

Example...

-----------------------------------------

| (From Miles) (ToMiles) = (Money) per (Miles) |

-----------------------------------------

all of the ( ) are fields in the portal.. The user can basically add add as many lines as you want.

Heres my question.. I need to make sure the mileages dont overlap or theres a gap between the different from&to mileage records. Is there a ez way of doing this? Im also trying to figure out if theres a way to get what record someone is on in the child file (from&tomilage portal) when they are in that field. Any ideas? thanks If I can I would like to do this without scripts if possible (a custom function would be nice or another way)

Thanks

You want the FromMiles to be the same as the ToMiles in the previous record, that refers to the same userID. I would create a relationship of userID=userID and milesID>milesID, be careful to get the sorting correctly, and then make an autoenter of the FromMiles based upon this relationship (I'm assuming you have a table Miles and another User with ID's serialized).

Your second part seems to be how to assign the mileage utilized to a child (account). I would somehow make it clear to the user which account currently being utilized by having a global in the Miles table gCurrentAccount. When your user is on the child file, then gets to the Miles file, I imagine from a button that takes you to that file/layout, simply set that gCurrentAccount. Then autoenter a field in Miles to that global. All done without scripts (I hope).