Limiting Drop Down Value use

[mindbender]

thanks - good to know for future reference

I have attached the existing relationship diagram that I just created. I am unsure how to go about adding the autonumbered and foreign keys to tables that already have thousands and thousands of rows without causing any issues.

[orange]

Can you provide a 3-4 line description of each table?
Do you have a business description similar in detail to the one in the tutorial?

tblMain does not tell me the purpose/rationale for the table.

Seems you have as the bass of the "business" a number of Accounts. And with each Account there are a number of Activities (not sure what these are or how they relate to Accounts).
I do see AccountType, which may indicate another table.
I also see Employee which is a redflag that a table is missing (probably)

I see a lot of detail re PrimaryContact-- I'm thinking you have a number of Contacts per Account and one of those Contacts is considered Primary (best guess based on names)
Outcome seems to be related to Activity?? Can 1 activity have multiple Outcomes? (may be missing table)

What is Industry? and How does it differ from PrimaryIndustry? (potential table)
Seems Company should/could be separate from Account?
What is Owner?
What is with all of the Xerox references? (hidden entity)

[mindbender]

here is the attachment

[mindbender]

Hi There,

I thought I would try and describe my issue again in as simple terms as I can think of to see if it triggers anything for anyone.

When the user chooses a value from the activity type drop down that contains the word "lead" (4 values fit this criteria out of 15 possible values total in the drop down) (which is a combo box pulling its values from the Activity_type table) before the record is added I would like to look in the Activity Table-Activity type field to see if that value has already been chosen before for that account (marked by account id). If the value exists in the table that indicates they have already used the value and should get a message pop up. If the value has not been used before for that account or is one of the other values that does not contain the word "lead" then allow the record to be written to the table.

Hope I am being clear