Options

One record to multiple records in table box?

bbcaibbcai Member Posts: 80
How can i insert multiple records in table box from a table record?
For example:
If there are 3 fields in table A, then the form is able to display 3 lines. Is it possible to make it?

Comments

  • Options
    eromeineromein Member Posts: 589
    Say WHA!?

    Could you be a more detailed....
    "Real programmers don't comment their code.
    If it was hard to write, it should be hard to understand."
  • Options
    bbcaibbcai Member Posts: 80
    Example: If there is a table with 3 fields:
    Table A (Field 1, Field 2, Field 3, Boolean 1, Boolean 2, Boolean 3)

    I want to get a record from this table and put it as 3 lines in table box (Form) and update it only during posting.

    Example: (Table Box)

    Features...............................Ticked (Boolean Check)

    Feature 1 (From Field 1).........Boolean 1
    Feature 2 (From Field 2).........Boolean 2
    Feature 3 (From Field 3).........Boolean 3

    How can this be done?
  • Options
    eromeineromein Member Posts: 589
    Either you'll need to make a tabular form or a Matrix form.

    Click the link below to lookup Matrix forms!

    Click this link to download the Navision Bible!
    "Real programmers don't comment their code.
    If it was hard to write, it should be hard to understand."
  • Options
    bbcaibbcai Member Posts: 80
    I cannot download from the link... Can send to my email?
  • Options
    eromeineromein Member Posts: 589
    Why can't you download the file. What is the error you get?
    "Real programmers don't comment their code.
    If it was hard to write, it should be hard to understand."
  • Options
    bbcaibbcai Member Posts: 80
    I have tried to download again today and it is successful. Does it explain how temporary table works on table box???
  • Options
    eromeineromein Member Posts: 589
    No, but, I think, it does explain how to make a matrix form.
    "Real programmers don't comment their code.
    If it was hard to write, it should be hard to understand."
  • Options
    WaldoWaldo Member Posts: 3,412
    I don't know for sure if I fully understand your problem, but here are my thoughts:

    You can create a temporary table, and insert the values in this record-variable. To show this in a form, you can do it by:
    FORM.RUNMODAL(FormID, myTempRecordVariable)
    

    Using temporary tables should help you dealing this problem ...

    gl

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
Sign In or Register to comment.