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