Show record list from a different company

Djou2424

Hi,

I need help for one of our client.
We need to show the location list from a different company, in a form, and retrieve the record selected by the user into in a field.

Here is what I tried, but it is always showing me the location list of my current company.

recLoc.RESET; //record Location Code, temporary NO
CLEAR(frmLoc); // form Location List
CLEAR(tmpLoc);
tmpLoc.DELETEALL; //record Location Code, temporary YES

recLoc.CHANGECOMPANY("Company Name");
IF recLoc.FIND('-') THEN
REPEAT
tmpLoc := recLoc;
tmpLoc.INSERT;
UNTIL recLoc.NEXT = 0;

frmLoc.SETTABLEVIEW(tmpLoc);
IF frmLoc.RUNMODAL = ACTION::LookupOK THEN
BEGIN
frmLoc.GETRECORD(tmpLoc);
"Location Code" := tmpLoc.Code;
END;

What am I doing wrong?

Thanks
-Julie

P.S: I also tried setting the form view to the recLoc directly instead of the temporary table, same results.

FelixAntony

Try tmpLoc.changecompany("company name") before copying the records to temp variable

kine

The probelm is that you are using SETTABLEVIEW. It is passing only filters, not the record itself.

Try to do it easily:

Loc.CHANGECOMPANY("another company");
IF FORM.RUNMODAL(0,Loc) = ACTION::LookupOK THEN
BEGIN
  "Location Code" := Loc.Code;
END;

You even do not need to use temporary table...

Djou2424

kine wrote:

The probelm is that you are using SETTABLEVIEW. It is passing only filters, not the record itself.

Try to do it easily:

Loc.CHANGECOMPANY("another company");
IF FORM.RUNMODAL(0,Loc) = ACTION::LookupOK THEN
BEGIN
  "Location Code" := Loc.Code;
END;

You even do not need to use temporary table...

Thank you very much, it's working