Hi guys

I need help from someone cleverer than me.

I have a medical record keeping solution in which I document amongst other things, eye pressure.

There is on entry per visit but not every entry has pressure recorded.

What I need to be able to do, is display in a portal, only those non empty values. i.e the empty one shouldn't show.

I can only think of a complex way of doing it which involves calculation fields.

Can anyone suggest a simple way of achieving this?

Joseph

If the pressure reading is recorded in a field in the child table, create a calc field in the child table flag_pressure, which equals 1 if not isempty (pressurefield).

Then build a relationship from the parent by primarykey to foreign key and constant1 = flag_pressure. This will find all child records that have a value in pressurefield.

OR, just use the List function to gather all values in pressurefield into one field in parent.

Many thanks

I like the list field idea

Joseph