Ambiguous outer join- 2

[Joeclueless]

I am trying to develop an inventory/update database with input forms and report generation capabilities. This is somewhat difficult to explain here without showing someone what I have.

There are 5 tables. Projects, Layer, Update, Additional_Elements and Elemental_Link.

The Elemental_Link table came from the table analyzer.

[Projects] is the primary table (at least thats how I see it) and it is related to [Update] and [Layer] by the [Projects.ProjectID] field. This is where I think the first problem is. Im trying to get my head around this relationship thing but...
Maybe someone could help me out of this jam.

Thanks again!

Joe

 

[mikey69]

Really need to see what you've done to offer any useful comment. E mail it, if it's not to big

youmike@mweb.co.za

 

[LittleSmudge]

As discussed in another place Joe - you need to sort out the One to Many relationships between Projects, Layer, Update and you need to consider the structure of Additional_Elements and Elemental_Link


The existing Additional_Elements and Elemental_Link table contants may well have been generated by the table analyser wizard - but that does not make them RIGHT.

Think carefully about Normalisation Rules and the relationships will become apparent.


'ope-that-'elps.

G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need! :-D

 

[DonQuichote]

I get the message 'Ambiguous outer join' usually when I try to mix left or right joins with inner joins. When you use left or right joins, you will have to do everything in the same query with left or right joins. I you use inner joins, do everything in your query with inner joins.

Best regards

 

[JeremyNYC]

One way to make sure the outer joins work together is to make sure that all of the arrows flow out from one table through all of the other tables. If you have more than one arrow pointing into a table it won't work.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.


Remember to reward helpful tips with the stars they deserve.

 

[Joeclueless]

I'm not sure if I should red flag Mike69's post or not..

He asked me to email what I have and I did so. He then never returned anything to the thread or to me.

Is this being anal, or should this be red flagged. Thanks again!

Joe

 

[JeremyNYC]

Joe,

I don't think you should red flag it. He offered to help. He hasn't helped you yet. Maybe he won't ever. I don't think it makes sense of you to have any expectation of him. People help here out of a sense of community. I spend a lot of time helping people, but sometimes I'm too busy to follow through. That's just the way it goes. If someone posts something useful to you, that's great. If not, you're no worse off than you were.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.


Remember to reward helpful tips with the stars they deserve.

 

[Joeclueless]

This is true.
Thanks again!

Joe

 

[mikey69]

Joeclueless - I didn't get your e mail. Have been away for a few days and found that several messages had been blocked because of viruses. Maybe yours was one. I do respond, if I get the e mails. try again if you still have a problem.

 

[Joeclueless]

Sorry Mikey....

Thanks for offer. I have somewhat fixed my problems. Well, at least the ones pertaining to this thread. Thanks again!

Joe