Forum Discussion

Qrew Commander

Re: LOOKUP FIELDS IN FORMS

You want to create a relationship where one inspection can have many violations. Then you can add multiple child violation records to an individual parent inspection record.

Here is what it would look like on a form:

You can change the settings so that you can add multiple child records from the parent record form:

Then it will look like this:

------------------------------
Adam Keever
------------------------------

3 Replies

DonLarson
Qrew Deputy
6 years ago
Becky,

Do what Adam said. He has laid out the whole architecture for you.

------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
RajHelaiya
Qrew Captain
6 years ago
Thanks Adam, I think this is an easier way to go. But I have a condition, if there are multiple fields in the child table and on the parent table I want to display certain fields based on certain conditions, say if a check box is checked only show 2 out of 3 fields from the child table when add button is clicked on the parent form. How does that work?

------------------------------
Raj Helaiya
------------------------------
- AdamKeever1
  Qrew Commander
  6 years ago
  You would need to use dynamic form rules in the form settings:
  
  You may need to use a formula field to compute a result for multiple conditions and then apply a dynamic form rule to that formula field depending on exactly what it is you need to do.
  
  ------------------------------
  Adam Keever
  ------------------------------