Sorry its so confusing... I just have too many related db's on the go.

To sum it up, I can't get the relation between my comments db and the users db working.

This is gonna get weird.

"commentsbikereviews" is related to bikereviews -- "users" is related to both of them.

commentsbikereivews' userid field is called "commentsUserid" because it has to be different from the bikereviews userid. Since the "users" db uses is userid and not commentsUserid, it doesn't relate to "commentsUserid".

Basically, all of my db's are going to have to relate to the users db.

Does that clear anything up?

-----------
Jason Dulberg
Extreme MTB
http://extreme.nas.net