Adding records in another table's field via separate table
I have two tables in a database I'm building - A table of Companies (with fields including: CompanyName, CompanyAddress, etc) and a table of Products (with fields including: ProductName, ProductCompany, etc). I set up the ProductCompany field to be a drop-down field with a value list pulling data from the CompanyName field in the Companies table.
This all works great, but I want to be able to enter in a Company's name into my ProductCompany drop-down list field, and if that name doesn't exist already - create a new record in the Companies table with the name I entered in the CompanyName field.
How can I do this?