Linked records

[Xpiotouopoc]

Hi

I'm quite new to using access so apologies for the probably Newb question.

Currently I have 3 sets of tables -

Company - Stores the list of Companies

Clients Contacts - Stores list of Contacts and these have a relationship link to the Company field.

Project - Is another table which has a list of details - project name etc. Now I have a link to the companies which appears as a drop down box, and a link to the client contacts as a drop down box. However what I want to happen is when I select a particular company, the client box then should only show the clients that are linked to that company where as at the moment it's showing all the clients (currently 2 but thought I'd get it working before populating any further).

I assume it's do with the relationship link or validation but I can't seem to prevent them showing.



Any help would be appreciated.



Thanks

[orange]

Read this article to help understand tables and relationships.
http://forums.aspfree.com/microsoft-...es-208217.html