Create: A Prompt to ask for information when it does not exist in the base

Topic Labels: Formulas
785 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I have created a form. The form is about a “person” and their parentage. On the form, it asks for a mother and father to be identified. Because it is a family tree type situation, it is for related people. I would like the selection from the base to already be in there or added with a form, like the one I have created.
If a child’s name is put into the form, and the parents do not exist, I need a prompt to input the mother or father and their information will be entered into the database also. Kind of like, 'it doesn’t exist, so you’re going to create it at that time, to move forward on the form.
Can someone help me with that formula?
Thanks in advance.

0 Replies 0