Design of Address DB with external Company Name DB

Hi,

I'm still in the process of developing an address/contact database based on the Business Productivity Solution from Filemaker. Most feelds and features are the same we need.

What I'd like to change is the way of selecting the company for a contact: originaly it is a text feeld so I do have different typings of the same company (Arri, ARRI, ...). I changed this, to use a relation to a second company name database and open a drop down list in the contact db. But with a lot of companies, opening ths DD-List takes up to 50 sec. in iwp.

A suggestion is to open the company database from within the contact record and select the company the contact works for. But as this hint is from a commercial developer, I dont have a sample yet

Dose anyon can tell me what I have to do to get the compay name "send" to the right record in the contact database?

Thanks for any hint!

Edited July 29, 200817 yr by Guest
FM Version is V9