Question Help. i am trying to create a mulpiple selection

[nijopo]

Hello.

Added more info in bottom Post - an image of what i am trying to do. - seems so simple - but i cant get it to work

i am trying to create a database that logs all our orders... simple !!

other than i want to be able to click on the order and it shows all the details of the order.
under the order would be the plot/house number 1 - 200 .
then when you click on the plot number it shows which products are in that plot.
that could be multiple lines for various products.
i cant seem to get everything to link to enable me to do this (simple anyway)

is there an easy solution that i have missed.

any one ???

thank you

 

[asteadman]

It's hard to advise without seeing the database design but the way I see you doing this is...

Having a form based on the order.
Subform1 - based on a query to find all the plots for that order.
Subform2 - based on a query to find all the products for that plot and order.

 

[nijopo]

ive added a VERY rough screen layout in the first post (Image)

the database is wuite simple and works, other than trying to sort the plots and then plot details below that.
i would like to be able to somehow list a range of plots ti show how many are on the order(at a later date make them change colour or put coloured boxs next to each one to show the status(i can dio that)
all i really want is when you click on one of the plot numbers that a form opens showing showimg the various lines of order details.

???

cheers