Database help

[cbrooks]

Hello,

I am trying to implement a database at work for logging customer details and communications.

I am struggling to select a contact for that company in the communication log. So when you log a call I want to be able to select only the contact names for that company.

I have attached the sample database to see if anyone can assist me.

Thank you for your help
Carl

 

[Big Pat]

What you're asking for is called a "cascading combo". You select a value form one dropdown and then that changes the values that are available in the second. E.g. if you select "Customer A", you get to choose from Adam, Andy, or Anne, but if you select Customer B, then you get to choose from Barbara, Brenda or Bob

Search this site for cascading combo and you'll find lots of useful threads. That's how I learned it

 

[Big Pat]

Oh...and take a look at Bob Larson's excellent site http://www.btabdevelopment.com/ts/samples

"Cascading combo sample" about halfway down.

I've learned a lot from Bob!

 

[MarvinM]

Carl,
Don't want to make a big deal about it, (I'm fairly new here too) but it would help you to put a better title or subject line when you post a question. A good title will attract experts who know about that topic. Again, not a big deal, but just want to help you get more/better responses to your question.