Forum Discussion

JeffAmmon's avatar
JeffAmmon
Qrew Member
8 years ago

Need help mapping 2 fields during form filling

Hi I have 2 tables.  1. Project 2. Sub Projects - This is related to 1 in one to many relationship For e.g. a project could be "Product". A sub-project could be "Product Harmonization", etc ...
Ask about Quickbase functionality
MCFNeil's avatar
MCFNeil
Qrew Captain
8 years ago
You will want to see the [Related Sub Project] field to be conditional.

On the Action Items table, find the reference field from the Sub Projects to Action Items.
its most likely called [Related Sub Project].

When you edit the field properties, you will see a checkbox 


Use that checkbox, and then in your case select from the dropdown "Related Project"
In my image it has [Related Client]

Then you will only see the sub projects, connected to that master project.