A portal problem...

[kshack201]

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

[dkemme]

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).