Problem with form display

[ds_8805]

Hi Everyone, I am trying to create a form based on 4 tables.
The tables are :



SiteInfo Table
Contracter Table
Project Table
Purchase Table.

The relationships for these tables are as follows:
SiteInfo table is related to Contracter Table by the contracter id and it is also related to the Project table by the project id. The purchase table is related to the product table table by the project id.

Initially, I had only the first 3 tables (siteinfo, contracter, project ) and any forms I created using all these 3 tables together, there was not any problem. However, with the addition of the new purchase table, nothing appears in the form in the form view. Could any of u tell me what I might be doing wrong and how I could possibly go about solving it?

Any help would be greatly appreciated! Thanks

[khalid]

Is your form is based on subforms each for different table OR it is based on a combined query of all the three tables?

[ds_8805]

the form is based on a combined query for all the 4 tables. thanks!

[Gerry]

Please post the SQL for the underlying query.

[ds_8805]

Hey I just realised that the form is able to display when I change the relationship for the purchase table. Now instead of linking it to project table, I have linked it to siteInfo table.

However I am still facing some problem. The problem now is that I need to create a report where the user should be allowed to select 5 sites and it should be displayed in the report. The thing now is that this 5 sites are randomly selected. I dun really have a clue on how to do this. I hope u can understand wat I m trying to ask.

if u wan i can attach my db also but i dun really noe how to attach it here.

thanks

[Gerry]

What you want is simply a query with 5 "OR" criteria. That's simple enough. You just need 5 fields in a form, which feed the query its criteria. Start by creating the query that will do this (using static criteria). For instance, if the field is JobSite, you might have these 5 criteria in that column:
"Ashwood St."
"Parking Deck"
"Stimpson Building"
"Croft St."
"Taj Mahal"

Once you have the query working, you need to create a form that executes the query to feed a report. On that form, you'd have 5 selection boxes for the user to choose the sites. Then, your query criteria would change to:

frmSelection!lstSite1
frmSelection!lstSite2
frmSelection!lstSite3
frmSelection!lstSite4
frmSelection!lstSite5

There are other ways, too.

[ds_8805]

oohhhhhhhhhhh what a great idea. This did not strike me before. Thank u so much! will def go try this. Thank u!!