Relationships errors In Access 2000

[webstaff]

Hey Guys,

I hope someone in here can assist me with my database,
Ive posted on the VBS board with this issue but as its the database thats the problem perhaps this is the forum to post in.

Anyway,,Here goes(Long story comming)

I made up a database of staffordshire bull terriers for my homepage, it consists of around 12000 records each with around 15 fields of info.

I want to be able to do several things with the database.
1: search for a particular dog and display its records,,then display the dogs pedigree via a go to detail page link done in UD4,

2: Display the dogs Title alongside their names in the generated pedigree.

3: Display a dog and show its offspring via a link also on the results page.

Now ive managed to get my point 1 completed and can display the dogs full pedigree no problem at all, I had some help building a set of querys that build on each other using relationships between to generate the dogs needed. This seems to work well.

Now these querys compries of 6 in total so i started in the first query and added the title field from each of the parents within the querys. I have got them all added except for the last query which generates errors and just will now run.
The massage is as follows:

The specified field '[qry_sbt5].field_title' could refer to more than 1 table listed in the from clause of your SQL statment

Now I went into the query [qry_sbt5] and there is no field_title?? im puzzled,
I am somewhat of a newbie and would appreciate any thoughts on this.
I have some of the pages running on a brinkster server where you can see how my pages are set out. just hit the main search and it will bring up the pages in question.

http://www31.brinkster.com/webstaff/

Thanks in advance to anyone who can assist.
Regards
les

 

[annsolomon]

Did you look at the SQL behind your query? Sometimes when you make changes to a query the QBE view is altered but not the SQL view.

 

[webstaff]

There must have been something there right enough,
So I started from scratch, I have 5 querys to build and when I get to the 5th query and start to build Im told the query is to complex and wont let me make the query.

So i thought i could split query 5 into 2 so Id have an extra query6, but as soon as i take query 4 into the relationships view and add tables to link it to it just wont do it, It keeps saying that the query is to complex??

Any suggestions are very welcome, Im so near to completing stage one.

Thanks again
Les

 

[annsolomon]

Hi Les. My email notification hasn't been working right lately; I haven't been ignoring you.

I'd suggest a visit to Microsoft's website to download the latest version of Jet. Jet's not the most powerful engine and, although newer versions have gotten better, there are still limitiations on how many tables/fields it can handle in a recordset. If downloading the latest version of Jet doesn't resolve your problem, I'd recommend that you try to trim the info you're putting in the query. Ann