How so I set a form field to be populated with an entry from another table?  I created a view on my source table limiting the results to just the one thing I want to see.

When adding a Client via my Add Client form, I want the Client Type field to already be populated with "INTEGRATOR" to remove one step.

This method forces me to still choose "INTEGRATOR" from the drop down when I am processing an entry via the CLIENT form.