Kelly,
This may be a typo, but when you set a relation you use the field name:
Set relation to
ticket into itemdata
Barbara
>I'm trying to setup a relationsship between 2 cursors. What I want to do is when I'm scrolling through 1 grid I want the other one to update its records occording to which record im currently on in grid 1. Here is my code
>SELECT Tickets.ticket, Tickets.loandate, Tickets.loanamt,;
> Tickets.paiddate, Tickets.paidamt, tickets.ptype, tickets.trnstype;
> FROM tickets;
> WHERE Tickets.custnr = "SD00357";
> into cursor ticketdata
>index on tickets.ticket tag tick
>
>SELECT item.ticket, Item.item;
> FROM item INNER JOIN ticketdata ;
> ON Item.ticket = Ticketdata.ticket;
> into cursor itemdata
>index on item.ticket tag tick
>
>select ticketdata
>set relation to tick into itemdata
>
>I get an error tha says "varibal ticket not found" in my set relation to tick into intemdata code.
>
>Thanks
>Kelly