>I have a 1-1 relation set between 2 tables, and fields from both tables mounted on a form. The relation is set as so:
>
>
>use hours in 0 order wcode
>use main in 0 order wcode
>select hours
>set relation to wcode into main
>
>
>Fields from table
main are informational, with the text boxes set as not enabled. When a user adds a new record in the
hours table, the first thing that happens is that they must enter a work code. I would like the relation to take effect and show the corresponding information from table
main. As it is, you have to move off the record and come back to get the information to show up. Refreshing the form does no good unless you move the record pointer and return to the record. These tables are set up with buffering, and in the middle of a new add, I don't want anything inadvertently being saved, which will happen if the record pointer is moved.
>
>Any help is appreciated
I think that issuing a GOTO RECNO() would re-etablish the relationship for you. You might try that instead of moving off and back to the record.