Creating Client Ids For Contact Database

[JJohnsonTC]

Hello all,

I've been building a contact database for my company, based off of the "Contact Management" Starter Solution in FM10 for awhile now. We've got just under 6000 contacts, many who share the same company as other contacts within the database. Currently, I'm trying to generate four or five digit Client ID's for each company represented. Is there a way to create a script, so that every contact with the same company gets the same ID code, but if the "Company" field is different, a different ID is generated?

Hope that makes sense, please let me know if any clarification is needed. Thanks for reading!

[projay]

So are you trying to keep the many contacts attached to one company?

[JJohnsonTC]

Yes, I want to keep all contacts still attached to their respective companies.

[dansmith65]

Is there a way to create a script, so that every contact with the same company gets the same ID code, but if the "Company" field is different, a different ID is generated?

If you are planing on basing this script on exact match of "Company" field, then why do you need the ID code to be the same? You could just base your relationship on the "Company" field.

[Rick Whitelaw]

If you are planing on basing this script on exact match of "Company" field, then why do you need the ID code to be the same? You could just base your relationship on the "Company" field.

Companies, like people, change names. Serial ID, PK and FK, is the way to go.