printing the Field in the report!!

[renante]

Hi Everybody!

I have form with a combo box selecting client code from clients table. Because i wanted to limit the size of my record,I only get the code of clients to be included in my sales table. However, when i tried to print the sales form only the code appears! I tried to put the clients name from clients table but it won't even appear!

Thank you in advance!

 

[tesar]

Do you have
SELE client
INDEX ON code TAG code
SELE sales
SET RELA TO code INTO client
or similarly ?

 

[ramani]

Hi,

SELECT Client Table and set the order to ClientCode. I assume you know this... example.. USE client ORDER 1 alias client etc.. and orer 1 is assumed to be a tag of client code....

Select SalesTable
SET ORDER TO clientCode INTO client

Now generate the report and in the report.. in the place of client name... put the code...
Client.ClientName

Hope you get the idea. ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com
LET KNOW IF THIS HELPED. ENOUGH EXPERTS ARE HERE TO HELP YOU OUT! BEST OF LUCK