Display companies on another table
So I created a database containing almost 200 contacts on one table. Each contact has a company associated. I want to make another table with just the companies, so the same company doesn't appear twice. Also, I want it to bo automatic so when i create a new record on the contact table and associate it with a company, it automatically updates the company table with a new company, is that possible?
The other thing is, when i create a new record on the contact table and want to associate it with an already existing company, how can i get FileMaker to auto-fill the data so i just need to put e.g. the company name?