Directory Database

[bwaters]

I'm basically setting up a directory management database for a project, i'm a beginner to Microsoft Access and having trouble to create a form relating Directories to Clients.

Obviously one client can be in many directory, and one directory can have many clients. So I have set up another table relating clients to directories, with their IDs and set up the One-to-Many relationships accordingly.

My database works fine if I want to link my tables together using the IDs in a form, so i type in my client ID and my directory ID and it works fine. So I think my relationships are fine



The problem is, i want to link them together with the client name and directory name in a form with a drop down box. So I can select a client name from my client table (in a drop down box), a directory name from my directory table (in a drop down box) and the data will be included in my other table.

But I can't seem to do it, i know it will be a simple thing that I have to do.

Hope it's clear and i can get it solved asap!

[alansidman]

If I am understanding you correctly, then you will have to join your two tables in a query. Make that query the record source for your new form. Now you can create combo boxes to look up the records. Look at this site to learn about combo boxes. Scroll down the page and you will find three tutorials on combo boxes.

http://www.datapigtechnologies.com/AccessMain.htm

Alan