Tyler,

Are you in FPW2.6? Otherwise a view in a grid in VFP may be better.

In FPW2.6 - are you doing anything else in your browse besides maybe locating a record? If not, you can select most of the columns from the main table, plus the lookup column from the description table and show that in your browse. Then if you need to, locate the record in the "real" table based on the selection in the cursor.


>I have a browse window that I have defined and it displays the table just fine. The problem is that I want it to lookup the value of the assignment ID saved in the table and find the assignment description in the assignment table. Is there any way to do this? Here is my window definition...
>
>define window asswin from wrows()-20,6 To wrows(),scols();
> in screen double close nogrow nozoom font 'Arial',7 halfheight
>move window asswin Center
>browse noedit noappend nodelete;
> Title "Press to return..." window asswin
>release window asswin
>RETURN