creating view with dropdown field when form doesn't have a dropdown field
I'm sure there's a quick easy answer to this question, but I've searched and cannot find it.
My main form in my database is a company information form.
I set up the field Company_Name as a dropdown field and when I created my view, I was able to scroll down, pick the company and view/edit it's details. This was perfect.
Unfortunately, I cannot add any new records as I cannot add to the Company_Name field because it's a dropdown field.
It's important to be able to scroll and pick the Company name in my view as I have several hundred companies listed.
Is there any way to add a mirrored field to my form that will show the data from Company_Name so that I can use this field in my view as a dropdown, leaving my company_name field as single line so I can add additional records?
many thanks,