I have a database I use as a point of sale system. It is for keeping track of which zip codes a realtor is assigned to represent. I have 3 tables.

1. Agent Info

2. Orders

3. Order detail.

-Agent info is just that. Contact info and the like for that specific agent.

-Orders is the parent of order detail and basically is there to allow there to be numerous orders for each agent and still different zip codes per order.

-Order detail is the zip code info for that specific order.

The problem I'm running into is this: I would like to have a lot of this info on one page. When I select the order on the left, I'd like to display only it's childs records in the portal on the right.

I'm unsure the best way to "select" my order record and how to only display those records. Currently, I get all of the records for that agent no matter what I do.

I know I probably didn't explain clearly enough, but any input would really help. Also I suppose I could upload the database so someone could look at it for me if that would help.

Thanks.

See if this thread is helpful.