FORMS5 Relation HELP

I have got the following two tables

  sales_companies

  sales_company_code       sales_company_name
    000039292                 Hitachi
    000039294                 JVC
    000004554                 SONY

  dailysales

   sales_company_code sales_qty

   000039292                 54
   000039292                 43
   000039292                 44
   000039294                 32
   000039294                 23
   000039294                 23

what I want is to display the sales company name in my form with the sales company code and sales qty

 As follows
dailysales

   sales_company_code sales_qty sales company name

   000039292                 54       hitachi
   000039292                 43       hitachi
   000039292                 44       hitachi
   000039294                 32       JVC
   000039294                 23       JVC
   000039294                 23       JVC

If iuse the follwing relation
 sales_companies.sales_company_code = dailysales.sales_company_code I get the following

dailysales

   sales_company_code sales_qty sales company name

   000039292                 54       hitachi
   000039292                 43
   000039292                 44
   000039294                 32       JVC
   000039294                 23
   000039294                 23

How do I get it so that form display the sales company name in all rows. I do not want to use views

any help appreciated

regards

michael

[Quoted] -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 27 1998 - 09:57:31 CET