Suburb / City Query

[Melissa]

Hi

I have created an "Advertising" database.

I have a form for "Advertisers" , "Restaurants", and "Placements".

Advertisers advertise their business on laminated ads in restaurants.
On the "Advertisers" form, there is a subform for "Placements", where the
user selects various Restaurants in which the Advertiser's Ads are placed.

This all works fine.

Now, I would like to create a form in which the user can search for all ads
placed for example in "Johannesburg". (City).

In other words, the query would look up the "restaurants's" city, not the
city where the advertiser's company is.

I hope this is making sense....
I would perhaps like one form on which the user could either search by city,
or by Suburb...etc

Thank you kindly

Melissa

 

[KARL DEWEY]

You said absolutely nothing about your table structure.
Do you have a City table set one-to-many to your Advertisers and Restaurants
tables? If so, then have City in form and Restaurants in subform with
Master/Child links using the City primary key to Restaurants foreign key.