>Hi,
> I have 2 table that related with master and child relationship.
>
>Customer
>Cust_ID, Cust_Name
>
>Sales
>SalesNo, Cust_ID, Amount
>
>
>Relation: (one to many relationship)
> I would like to get Cust_Name once user browse Customer Sales record without LOCATE to customer table again using Cust_ID.
> Any suggestions?
>
>Thank you
John,
A relation doesn't prevent you from browsing to other records while parent hasn't changed. IMHO in that case best way to get cust_name would be :
select cust_name from parenttable ;
where cust_id = ChildTable.cust_id ;
into array arrTempCustName
Cetin