Take customer's name from all companies

try the

CHANGECOMPANY

command

Remember that after you changecompany you must then reset your filters and set the range again.
Are you running a report or a form?
Do you have an examle of your code?

To help one of your problems, then you should try looking at the Company table. Simply loop through it, and then you don't need to hardcode company names in your code.

However, it seems you try to show customers from all companies in one list, is that correct?
Then you will have to create a new table, unless you know (or is allowed to assume) that no Customer No. is used in more than one company. Then create a new table with primary key Company,"Customer No."
Then let your code loop through the companies and for each company loop through customers and fill a temporary record variable. But if you have a lot of customers it might take quite some time. A different solution could be making the new table DataPerCompany=No and ensure it was updated when the customers are updated. That would be quite a big task, but not impossible. If you are using SQL, you could create a SQL View. However, then I still think you'll need to hardcode the companynames.

I'll recommend not using the standard customer list form, eventhough you might get told that no customer no. is reused in multiple companies. All the functions and sub-views will be messed up when you try to do anything with a customer from a different company.

Depending what your client is trying to gain from you help, the solution might be to mark the Customer table as DataPerCompany=No.

damn,

and i thought i was onto something here.

](*,)

Something like this:

IF Company.FINDSET THEN BEGIN
  REPEAT
    Customer.CHANGECOMPANY(Company.Name);
    IF Customer.FINDSET THEN REPEAT
      TempCustomer.INIT;
      // set all fields, use transferfields or copy or whatever else works
      TempCustomer.INSERT;
    UNTIL Customer.NEXT = 0;
  UNTIL Company.NEXT = 0;
END;

I'm writing this off hand, have not tested it.

It looks like you should read the application designers guide and maybe even the developer training material, because it doesn't look like you understand record navigation in C/AL code yet.

Hahaha, now you are pushing it

The only way i know of to do that is by making a view on the sql server.

I mean that you are making it harder and harder on yourself.

And me, the joyfull person that i am, i thought i would give you the answer with a little laugh.

So no need to search for a deaper meaning , is this a cultural issue for you or did you just not understand, i'm interested?