I have a table that stores articles and documents:
ID - int(10) key
personID - int(10)
articleType - varchar(10)
title
article
.
.
.
The field "articleType’ has the value ‘Article’ OR ‘Document’
I am trying to create a tab panel that will display all documents on record for a selected person. I created a relationship based on personID and a global with a default value of ‘Document’ to articleType:
personID = personID
global.document = articleType
The relationship acts invalid. I know I am thinking to “FM” but is there another way to do this? Why does this not work? I could have swore it worked in an earlier version.
Any input would be appreciated.