I fill my business object by 'Select * from cowboys order by cow_lastname, cow_firstname' and then it comes in alphabetically. But when I add a new cowboy how do I keep the data in Alpha order? The form is a SF maintenance form but the navigation keys no longer work after I add a new cowboy. ???? TIA.

Check out the Sort property on the BO.

I would tend to agree with Greg, it sounds like you have a Sort on your BO.  Check that and if that doesn't resolve your issue let us know.

OK I will and let you know.

Or a filter....this is can be a culprit as well.  Check the Sort and the Filter just in case

Hey Terry.

I know it is a cowboy's table, but "cow_lastname" and "cow_firstname" sounded really funny for me...

I'm Brazilian, it is not my fault to be silly like this...

We have a lot of cowboys from Brazil in Cheyenne Frontier Days, the largest out door rodeo, and they are very good.

I looked for the sort property and could not find it on either the BO in the project or the instance on the form. What am I missing? TIA

It is a property on the BO:

If you have either of these set and add a new record, you generally get the behavior you are experiencing.  I would imagine that some type of filter or set is set.

I'm sorry, I am either not looking in the correct place or I am just missing the boat some how. I can not find either the sort or filter property in the property window on either the BO in the project or the instanciated BO on the form. I have sorted the properties and looked at them that way and still can not find them. What am I missing????? TIA.