Newbies Tom Harvey Posted July 30, 2020 Newbies Posted July 30, 2020 Hi everyone, My title may be a bit obscure, so I’ll explain. I am using FM 16. I have records that hold the results of ancestry research. Each record has one main person and several other persons. So sometimes person A is the main person in a record and ‘’another’’ person in a different record. I have a portal that displays all the records. I’m filtering this portal using a global field and a value list. The problem I have is this: if I pick, say, person A in the dropdown list, what I’m getting in the portal is all the records where A is either the main person or ‘’another’’ person. I’d like to be able to filter the portal further by choosing, say when I select person A from the dropdown, whether I want the records where person A is the main person or only those where person A is ‘’another’’ person. I guess I could use a Case function in the filtering calculation of the portal, but how can set up the dropdown list so that it gives me two options when I select a name? Thanks for your help.
comment Posted July 30, 2020 Posted July 30, 2020 9 minutes ago, Tom Harvey said: how can set up the dropdown list so that it gives me two options when I select a name? I don't see how it could possibly do such thing: the name of the person is the same name, regardless of whether they are the "main" person or "another" - is it not? Why not use another global field to make the selection between "main" and "another", then base the filtering calculation on that? A side note: 15 minutes ago, Tom Harvey said: Each record has one main person and several other persons. I am not sure I understand the structure you describe - and it does not resemble any structure I would think of in context of "ancestry research".
Newbies Tom Harvey Posted July 30, 2020 Author Newbies Posted July 30, 2020 Thanks for your reply. can you explain how this second global field would work? Would it use a different value list where the name of each person would be duplicated with one instance followed by ''main'' and the other followed by ''another'', or something like that? Would that be the idea?
comment Posted July 30, 2020 Posted July 30, 2020 The way I imagined this, the second global field would contain either "main" or "another".
Recommended Posts
This topic is 1632 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now