need help... regarding relationship

roshanthapa · 2007-10-08

Please enlighten me:

I have two tables and two forms called branch and brand. The brand contains the ralation with branch.
That means the brand contains a field called branch which has relation with branch table. Now The branch also has a list whose editable is set to false.

In my case, the branch list should be non-editable when I press f5 in branch form and should be editable when I lookup from brand table. Please tell me how can this be done. Any help will be appreciated.

roshanthapa · 2007-10-08

Or we can take this question as "How can we change the properties(like visible or editable) of the form(generally list) from the table/form from which it is being looked-up?".

Revolution1210 · 2007-10-08

roshanthapa wrote:

Or we can take this question as "How can we change the properties(like visible or editable) of the form(generally list) from the table/form from which it is being looked-up?".

Create a function on your list form called SetEditable.
Pass this function a Boolean which you can use to set the mode of your form

CurrForm.EDITABLE(YourBooleanVar)

Code your lookups similar to:

YourFormVar.SetEditable(TRUE);
YourFormVar.RUN;

roshanthapa · 2007-10-08

with this code, we can display the list in editable mode but this will not return back the value to the field from where we clicked lookup.

Any further suggestions?

Revolution1210 · 2007-10-08

roshanthapa wrote:

with this code, we can display the list in editable mode but this will not return back the value to the field from where we clicked lookup.

Any further suggestions?

Set any filters:

YourTableVar.SETRANGE(... ...)
YourFormVar.SETTABLEVIEW(YourTableVar);

Set the lookup mode:

YourFormVar.LOOKUPMODE(TRUE);

Call your SetEditable function:

YourFormVar.SetEditable(TRUE);

Call the form, retreive the record and process as required:

e.g.,

IF YourFormVar.RUNMODAL = Action::LookupOK THEN BEGIN
  YourFormVar.GETRECORD(YourTableVar);
  Code := YourTableVar.Code;
END;

need help... regarding relationship

Comments

Categories