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

Question

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

Erwin Ekkel · Accepted Answer

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?

Erwin Ekkel · Answer

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.

Sign up

Login to the Thinkwise Software Community

Scanning file for viruses.

This file cannot be downloaded