Hi

Can anybody explain to me how to create reports?

I am trying to build myself a Real Estate Listings Database, that will allow me to add listings and then search and create reports.

My problem now:
I have created a table called houses, where I will add houses for sale, another table called area, where all the suburbs are listed, and a form called houses, where I then add the details of the house for sale, and select the suburb where the house is located.

I have created a report called houses, and this then displays the houses in the database.
So far so good. But how do I go and create reports for each suburb, listing only houses for that particular suburb?
Do I have to create a separate table for each suburb? And a separate report for each suburb?

If so, how do I create a form that allows me to select the suburb and then enter new data for that suburb,
and how do I then link this form to all the tables?

Would be grateful for an answer to this problem.

Thanks
Hans

Ok quite simple

you have a table for houses (yes)
and a table for Suburb (yes)

OK you need a combo box

b4 you do this enter your suburbs in the table (just a couple to start)
now make qry based on this table with hte information you wish to pull accross (I recommend at least the uniqueno and name of suburb0
save as suburbqry or wahtever makes sense to you

now make 2 fields in your house table one for the u suburb unique no and one for name of suburb
add these two fields to your houseform name1 and name2(or wahtever makes sense)
open your form in design mode add a combo box call it selectSuburb base this on your qry above and have the 2 fields in this unique no and name
and in the afterupdate of this you will see .... open up this in code

now you will need to remember the names on the form for the two fields you wish to have populated

so name1 = comboxname.coloumn(0) (Comoboxname will be whatever you called it selectSuburb) and the same for the second field but the coloumn willl be 1 -
after this you will need
.refresh and a save - copy the code from a save button






and

Hi Gary

Thanks for the reply. Will give it a try.