Form with Subform

zulq
zulq Member Posts: 204
edited 2007-07-09 in NAV/Navision Classic Client
Hi,
Created a form and a subform but having problems basing selections on the first form.
The first form contains text fields for employer No. and date received and a command button. Employer No. is chosen from the customer table and date received is to be typed.
It also has command button.
Now my problem I want when a user choose an employer/customer on the form and press the command button the subform to automatically select all employees for the employer/customer chosen.
Please help, have no ideas as how to achieve this...
Any ideas welcome please.
Few years ago we were not existing and few years to come we would be in the grave! So what will benefit us in the grave?

Answers

  • Bgestel
    Bgestel Member Posts: 136
    put a function on the subform that takes the wanted filters as a parrameter.

    in this function you use filters on the subforms rec var.

    In the parrent form you can call the funtion using currform.replacethispartwithsubformname.function(parameters).

    should do the trick
    **********************
    ** SI ** Bert Van Gestel **
    **********************
  • zulq
    zulq Member Posts: 204
    Hi Bgestel,
    Please excuse for being a novice in navision but have never programmed such a function before and not a trained developer yet.
    Below is the code I've being trying to modify: 
    "Populate(EmployerNo)"();
RESET;
Employee.SETRANGE("Employer No.",'NPF/20805');
IF Employee.FIND('-')
THEN BEGIN REPEAT
TmpItem."Employee No." := Employee."No.";
TmpItem."Full Name" := Employee."First Name";
TmpItem.COPY(Rec);
UNTIL Employee.NEXT=0;
END;

    Please let me know where am wrong or if this is totally the wrong way.
    Also when I push the command button I get an error:
    there is insufficient memory (stack) to execute this function

    Once again let me explain exactly what I want. I want an employer is selected in the main form and the button is clicked the function to return all the employees of the chosen employer to the subform which I based on a temporal table variable.

    Help please need this urgently!
    ](*,) ](*,) ](*,)
    Few years ago we were not existing and few years to come we would be in the grave! So what will benefit us in the grave?
  • JAYESH
    JAYESH Member Posts: 290
    I dont know why you need this thing..

    You can put subfomlink property, depends upon the employee seelcted its automatically filter the records.

    Thank you
    JAYESH PATEL
  • zulq
    zulq Member Posts: 204
    Jayesh,
    I don't think you read the post properly. Please do read properly before posting as such postings will discourage others from trying to help in solving the problem. Its not as simple as you thinking and please once again read it properly before replying.
    Once again, I want a subform based on a temporal table to be automatically filled in with all the employees and their details of a chosen employer.
    For example if it was a report you would have employer, and employee indented by 1 and thus when user choose an employer all employees of the chosen employer will be shown on the report.

    If your post is referring to the same solution please elaborate how to achieve this else let others try.
    Thanks.
    Few years ago we were not existing and few years to come we would be in the grave! So what will benefit us in the grave?

Categories