I haver a table called installations. It has a status Open and Closed. These are manually set. I have a layout called Home and on this is a portal showing all Open Installations. Simple so far. I then have another table, Purchase Orders. I wish to show all open purchase orders within a portal. The problem is that the Status (Open/Closed) is based on a calculation. The calculation is
In other words, if the item has been delivered, the record is marked as closed.
Any suggestions on the best way of achieving this? I am aware that calculation fields cannot be used for relationships as they are not indexed.