Taking Relevant data from another table

[Tatasumaru]

Hi,

I'm making a database for a college project and I want to put data taken from different table (data relevant to that record) into another tables form. Here's an example of what I've got and what I want to do:

2 Tables
Customer
Visit

(A customer can visit on many occasions and there are many customers)

So I want to have a list box showing all of the visits that particular customer made, I tried this myself, but all I can get is it to show all of the visits by every customer.

I also wanted each visit date in the list to be linked to the form for that date if that makes any sense. For example, Joe Bloggs has visited 5 times on different dates and it shows a list of those 5 dates on the right hand side in a list box, I then click on the date 25/06/2005 and it will bring me to the form displaying what he did on that particular visit. (so, it shows me a form from the "Visit" table of that particular date for that particular customer) This is only an example scenario of what I've got, but it's more complicated to explain my actual scenario, Any help would be good!

 

[Dennisk]

you need a main form containing the customer details, a subform embedded in the main form that show the visits. Then use the combo box wizard to create a combo box that will find a customer record. As each customer record is selected the subform should show the details only for the customer on the main form.