Hi Nancy

no chance you could create a more sensible structure for your own use then return the poor structure to the client :-)

You could have a table of boxers and a table of bouts. Bouts would contain just the foreign keys for boxer1 and boxer2 plus the bout specific data.

Nick Mason
>hi nick, thanks for responding. well i am trying not do that because there are about 60 different elements - textboxes, listboxes, labels, etc - that move around, and i was trying to do this without having to this.comment = STR(this.top) 60 times.
>
>let me explain why the need for the "movement". the client has a table that i cannot change, that contains records from boxing matches. it is a flat file table that has 60 fields. 25 describe boxer1 (age1, reach1, height1, etc) 25 describe boxer2 (age2, reach2, height2, etc) and 10 are common to both (referee, date, time location, etc.). say we have a boxer such as john smith; john smith might appear in the table either as boxer1 or boxer depending on how the match was entered. soooo... the client wants it such that if he is scrolling through john smith's records, john smith's info always appears at the top of the screen regardless of if he is boxer1 or boxer2.
>
>nancy.
>
>
>>Hi Nancy
>>
>>not sure why you want your text boxes to move.
>>
>>But you could store the top value in the textbox comment.
>>In the textbox init
>>this.comment = STR(this.top)
>>
>>Then restore to default by setting the top value to whats in the comment.
>>
>>ThisForm.Text1.top = VAL(ThisForm.Text1.comment)
>>
>>Nick Mason
>>
>>>i'm having a little problem with what i assume is a simple question. say i have a form designed with a text box where the ".top" property of that textbox is 100. when the program is running i move the textbox up and down the screen by programmatically changing the value of ".top". while the program is running how do i determine the original design-time value of ".top". i am basically adding a "reset to default button" and want the text box to return to its original position of ".top=100". i am assuming that value is accessible and i don't have to create a variable to store it.
>>>
>>>thanks,
>>>
>>>nancy