LOOKUP FIELDS IN FORMS

Question

I HAVE A INSPECTIONS TABLE AND A&nbsp; VIOLATIONS TABLE.&nbsp; I WANT TO BE ABLE TO CHOOSE THE VIOLATION WHEN CREATING A NEW INSPECTION.&nbsp; &nbsp;HOWEVER, INSPECTIONS CAN HAVE SEVERAL VIOLATIONS.&nbsp; WHAT IS THE BEST WAY TO SET THIS UP?&nbsp; I MADE A LOOKUP FIELD FOR VIOLATIONS BUT I DON'T KNOW HOW TO ADD MORE THAN ONE.&nbsp; OR MAYBE THERE IS A BETTER WAY.------------------------------Becky Moore------------------------------

adamkeever1 · Answer

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------------------------------

donlarson · Answer

Becky,Do what Adam said.&nbsp; He has laid out the whole architecture for you.------------------------------Don LarsonPaasporterWestlake OH------------------------------

rajhelaiya · Answer

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 · Answer

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------------------------------

Forum Discussion

LOOKUP FIELDS IN FORMS

Related Content

Lookup Field not pulling Data

Lookup Field Not Pulling Data

Pipelines: Lookup newest record?

Snapshot Fields

Way to do Editable Lookup Fields?