Hi, in my program. I have two dbf file, one is "staff" and the other is "Key".
I output the infomation to the report with the query below.
However as the "key.transfer" is the feild that in form of the ID number of the staff instead of NAME and it is not good. I wonder how should I write the query or other method that output the NAME which correspond to the TRANSFER(the name is store in the "staff" dbf file)


select distinct staff.staff_id, staff.name, staff.chi_name, key.key, key.category, key.d_to, key.d_return , key.transfer from key, staff where alltrim(key.category)="ACCESS" and key.key=thisform.text2.value and staff.staff_id=key.staff_id order by d_to into cursor ppp
report form transfer_report noconsole to printer prompt preview

I know my mail is quite long.I hope someone can help me..thx