AnsweredAssumed Answered

Adding records in another table's field via separate table

Question asked by DanielClark on Jan 7, 2011
Latest reply on Jan 7, 2011 by DanielClark

Title

Adding records in another table's field via separate table

Post

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?

Thanks

Outcomes