Flowfield???

ReSpongebob

Hi,

I have two tables:
Registration Header
Registration Line

The table Registration Line contains measurements that need to be performed. The results of a measurement can be one of the following:
1. Value (Decimal)
2. Choice (Option)

In order to have a valid measurement, one of the two fields mentioned above must contain a value.

I need a field in the Registration Header that indicates whether or not all Registration Lines have a valid measurement. (In other words: check every Registration Line that is related to the Registration Header, and check if one of the two fields mentioned above contain a value).

I've been thinking to use a FlowField here, but I'm not sure if it's possible to check if at least one of two fields contain a value.

Any help will be appreciated.

Marije_Brummel

You cannot do a flowfield checking the 2 fields

Best solution I think is to make a flag (boolean) in the line. You can set this flag in the validation trigger of Value and Choice. If the flag is true the values are good.

Then you can make an exist flowfield that checks the value of the flag.

Good luck.

DenSter

Mark, I'd like to know how you were planning to create a flowfield that checks to see if all lines related to a header record have a certain value. I know about the sum, average, exist, etc flowfields, but the SeeIfAllRelatedFieldsHaveTheSameValue type is new to me

Marije_Brummel

You only need to know if one is different.

So if one of the lines has the flag false the document is incomplete.

-Exist(lines WHERE Flag=FALSE)

(Ofzoiets)

Marije_Brummel

Negative logic

DenSter

I think you've just invented the SeeIfAllRelatedFieldsHaveTheSameValue type flowfield =D>