>>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
Optionally you could also use customer table again with another alias and set a relation to it from child (reverse relation). Then you only need to say :
Customer2.Cust_name
Cetin