Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Conditional Value List defined by a Portal Field

Featured Replies

  • Newbies

I am developing a database designed to contain examination questions. A growing issue is the need to accommodate several tiers of questions, 3 tiers, along with related answers/scoring keys. The organisation requires that all are visible on the one page (otherwise I would make another layout linking back to this using scripts), the 'Question Bank' encompases the group of records, however the 'Question' is the core table for this layout.

1. Question Bank (2)

2. Questions (2.1...)

Question Answers

Marks

3. Subquestions (2.1.1....)

Subquestion Answers

Marks

As such I was hoping to use a portal within a portal to relate subanswers to subquestions only to find that you CANNOT successfully place a portal in a portal (or so I've found and read) shocked.gif. The solution seems to be a Cond. Value List. BUT I need to create a relationship between the subanswers and their subquestion so that only the answers for that particular question are listed. I have the value list but the condition isn't activating and I am getting a list of all the subanswers in the subanswer field, not just those for that question. The field I have related, 'subquestion number', is within a portal on that particular layout which seems to be preventing the value list from identifying the value it needs to relate to.

How do I get this to work? What am I missing? If I have to build a loop script instead I will be lost blush.gif

Thanks

Nattani

PS: I have attached a screendump in word to help. I cannot attach the DB itself due to confidentiality issues.

Screendump(relationships).GIF

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.