Skip to main content
Solved

Fill look-up with filtered results from table unrelated to t1


Alex Kerschkamp
Captain
Forum|alt.badge.img+3

Hi everyone,

We're working an a screen showing a venue that belongs to a topic. There are more venues for the main topic. So, there are speakers for the topic, and the speaker is selected with a venue for that topic. So, the speaker is linked at the topic. The speaker has more topics he can speak about. However, we want to be able to add more topics to this venue. Each speaker confirms the topic at a later date if he or she is speaking about a topic at that venue.

We can't seem to get a list of topics (linked to the speaker) for the venue, so that we can select 1 or more topics to add to that venue. How would we best get this done?

So, we have topics, and topics have available speakers. Each speaker has one or more topics. We select a venue, and go into that venue. We then want to have a list of topics that are linked to the speaker of the venue. The venue is now our t1. Can we make a view of possible topics (linked to the speaker) in a variant of venue that contains all topics for the speaker of the venue, so that we can select 1 or more topics for that venue?

Thanks in advance for any help or ideas,
- Alex

Best answer by Erwin Ekkel

Why not a detail? In a lookup you can select only 1 option. And as you stated you need multiple options. So a detail with all possible topics and a task, checkbox, drag drop system to select multiple topics would probably make more sense? If you can elaborate on the need for the lookup?

 

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

3 replies

Forum|alt.badge.img+17
  • Moderator
  • 762 replies
  • August 18, 2023

i think you answered your own question. Create a view with all possible speaker topic combinations and show that view as a detail of the venue. 


Alex Kerschkamp
Captain
Forum|alt.badge.img+3

Hi Erwin, thank you :blush: The view we can make, but we need a topic-lookup filtered on the speaker at the venue, so we can link venue to multiple topics.


Forum|alt.badge.img+17
  • Moderator
  • 762 replies
  • Answer
  • August 18, 2023

Why not a detail? In a lookup you can select only 1 option. And as you stated you need multiple options. So a detail with all possible topics and a task, checkbox, drag drop system to select multiple topics would probably make more sense? If you can elaborate on the need for the lookup?

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings