Query based on current record

[James_Morant]

I am designing a contact management system and have hit a bit of a wall. I am farily new to Access so please advise if I am going about this the totally wrong way.

I have three tables; Contacts, Companies, Company_Addresses

Contacts:

ContactID (P)
CompanyID
OfficeName​

Companies:

CompanyID (P)​

Company_Addresses:

CompanyID
OfficeName (P)​

What I want is when adding a contact, to have a drop down list in the CompanyID field showing all the companies in the Companies table, and then in the OfficeName field, have a list of only the offices related to the company selected in the previous field.

I can do the first list, but cant work out how to list only data related to the company selected in the previous field. Any help would be greatly appreciated.

Sorry if this is in the wrong forum.

Thanks. James

 

[ajetrumpet]

Here is the microsoft article on the subject James, see if you can get something from it. If not, post back and explain what does not make sense.

Microsoft's Cascading Combos

I think you have a little redundancy in your tables too, unless there is more data other than what you have listed. You'll have to consolidate a bit to cascade your boxes.

 

[James_Morant]

ajetrumpet,

Thanks a lot, thats exactly what i was looking for.

James

 

[omontesg]

Here is the microsoft article on the subject James, see if you can get something from it. If not, post back and explain what does not make sense.

Microsoft's Cascading Combos

I think you have a little redundancy in your tables too, unless there is more data other than what you have listed. You'll have to consolidate a bit to cascade your boxes.

Hi Ajetrumpet,
Sorry I see no redundancy on Jame's database structure, could you show me where is it?