Hi Justok,

Thanks for telling me not to tamper with the table during run-time.

I solved it like this:
I used Afield() to get an array with fieldnames from the table, stored the fieldnames in another array, added a sortnumber in the new array, checked the preferred language, changed the sortnumber to 1 for the preferred language, sorted the new array on sortnumber. Then I use the new array when I create my popmenu or when I am changing the caption of the labels and the controlsource of the textbox. Voila!

It works and I still won't be changing any code if I add a new langauge.

/Pierre Unge, Sweden


>I agree Paul's view, it is not good on modify structre at run-time!
>
>1. You need to Exclusive right on table, it is NOT flexible for
>multi-user
>2. In case your application crash during reformat the table, you lose ur table!
>
>