List Box Question

[MikeAllen]

Hi everyone, I have a list box question....

Is it possible to have a list box list information from one record, rather than all records.

I'll do my best to explain here.....
In my main table I have customers (records). Each of these customers may be able to have an item attached to them?

For example, pretend this is a library and one customer has 3 books out. I want the list to show those 3 books for that customer.
Ultimately, I then want to be able to click on the item in the list box to show additional information about 'the book attached that customer'.

Currently, I can only get the list to show all books out for all the customers in my database...

I hope that makes sense, I'm not very good at explaining these things.

Thanks
Mike

[orange]

Please tell us more about your database. What tables do you have? What relationships do you have?
Can you post a jpg of your tables and relationships?

Books
Customers
CustomerHasBooks (junction to resolve M:M)

There are free data models that may give you some ideas at
http://www.databaseanswers.org/data_...ore_dezign.htm
http://www.databaseanswers.org/data_...ooks/index.htm

[MikeAllen]

Hi, the database is Insurance based. It stores customer claim information and third party 'claimant' information relating to those claims. It's where our insured is at fault, basically.
NB each claim can have multiple third party claimants.

By the way I'm using Access 97 not 2000 as stated in my profile (didn't have the option to select 97).

I have 2 tables...table 1 'tblmain' stores high level details about the claim (pol holder name, claim id, date of accident, circumstances etc..), the Claim_ID being the PK. Table 2 'tbltpdtls' holds information relating to 3rd parties (name, vehicle, address, vehicle damage, injuries etc...)
I have Claim_ID in both tables and (think) I have created a 1 (claim) to many (claimants) relationship in the relationship window (is that the 2nd or 3rd option in the join property window?)

All of this has been converted into a multiple form view and I have other functionality that allows me to search for claims and view the information for that claim.
However, this is where I'm stuck.... I want to be able view the claimant information for that claim in a listbox. Then I want to be able to click on that listbox on any of the claimants for that claim and view their information, which will be on a different form. The bit I need help with is just getting the list box to show the claimants for that claim and not all the claims, everything else I should be ok with.

Struggling getting image up at the moment, I'll try and upload one this afternoon (work constraints).

Thanks again
Mike

[orange]

You may get some ideas from data models at
www.databaseanswers.org

This one may be helpful
http://www.databaseanswers.org/data_...aims/index.htm

You should research Normalization.