Queries about technical of Nav 4.0

paul_navision

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?

papvre

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;

kine

paul_navision wrote:

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...