Creator: How to combine two forms into 1 lookup field?
Creator: How to combine two forms into 1 lookup field?
Form 1: Add_Invoice_Form
Form 2: Add_Service_Form
Form 3: Add_Material_Form
Forms 2 and 3 both have a field within them called "Name". We want to add a lookup field (dropdown) in Form 1 called "Service/Material Name". This lookup field should combine the "Name" field from both Forms 2 and 3. Is this possible?