Non-displaying records from a table.

Business Central/NAV Developers Forum
1

I would be grateful for some help with a development problem I have. I am using a master table to populate a list form. For some of the records read from the master table, a related record will exist on a second table, and if I can GET this record, then information from it will also be shown. Easy so far. However, what I also need to do is if a record exists on the second table and a certain condition exists, I want to prevent display of the record from the first table on my list. I have to use the first master table as the driver for the list as there are not always related records on the second table. Can anyone suggest how I can do this please Thanks in advance

2

Can you create a flowfield in the master table with that condition ? Like Exists(…) ?

3

If so, you can use a filter on the flow field. Not the fastest, but anyway. else you could use the form triggers OnFindRecord and OnNextRecord to skip the records which you do not want to see.

4

Another option would be to mark records. The correct solution usually depends on the number of records, available keys, read-only or modify, etc.

5

Navision allows flow fields to be based on other flow fields. If done wrongly it can be slow, but I have done what you are asking with reasonable success. Basically you create the first flow field int he top table that looks for the related value in a lower table. Then ou can use an exists flow field, and use the results of the first look up to determine if the compbination exists, and then just filter on showing only the TRUE values. Can you give some specific examples of what you want to achive, and I will explain it in those terms.

6

Thanks for the responses. I’ll work on an example and post it later today. Thanks again

7

Ok, this is an of the logic I’m after. In the example, I want to list all vendors, and if there is an outstanding PO for the vendor, I just want to output a tick in a control. However, if the Last Receiving No. is populated, I want to completely suppress the record for the vendor. Thanks again for the reponses to far.

8

Apologies for the typo. Meant to say “This is the logic I’m after”