Options

Queries about technical of Nav 4.0

paul_navisionpaul_navision Member Posts: 64
1.Q. At the time of create a table relation between two tables, if the table which is already in Navision and linked with a field of another table which is user created, table relation function will be worked. But when two tables are created by user and wants to create table relation property between them using one field of a table, table relation not worked. What will be the solve? What step we are missing?

2.Q. Loc.SETRANGE(HUB,TRUE);
Loc.SETRANGE(Branch,TRUE);
Loc.SETRANGE(OC,TRUE);

Here “Loc “ is a global variable. We are try use “OR” condition in “SETRANGE” Function. Above statements are worked as “AND” condition. What will be statement or function to use the logic?

Please solve the problems at the earliest?

Regards

Paul
Dynamics Nav Functional Consultant

Comments

  • Options
    papvrepapvre Member Posts: 24
    1. You have something wrong. When You Write more information, someone can help you.


    To the second question>
    I wil make it like this:

    IF Loc.FIND('-') THEN REPEAT
    IF Loc.HUB OR Loc.Branch OR Loc.OC THEN Loc.MARK(TRUE);
    UNTIL Loc.NEXT = 0;
    Loc.MARKEDONLY(TRUE);

    This will show only that records what u need. To clear marks Loc.CLEARMARKS;
  • Options
    kinekine Member Posts: 12,562
    1.Q. At the time of create a table relation between two tables, if the table which is already in Navision and linked with a field of another table which is user created, table relation function will be worked. But when two tables are created by user and wants to create table relation property between them using one field of a table, table relation not worked. What will be the solve? What step we are missing?

    2.Q. Loc.SETRANGE(HUB,TRUE);
    Loc.SETRANGE(Branch,TRUE);
    Loc.SETRANGE(OC,TRUE);

    Here “Loc “ is a global variable. We are try use “OR” condition in “SETRANGE” Function. Above statements are worked as “AND” condition. What will be statement or function to use the logic?

    Please solve the problems at the earliest?

    1) Do you mean that one field from one table should have relation into two tables? If yes, you need some option field which will differ in which table the field is realted. Like Type and No. fields in sales line... :-)

    2) Search throufh the forum, there are plenty of threads about that. I remember one right from this week...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.