ErocM

Can anyone help me get started? E

What do I use to "link" between the tables in a query though?  That is where I am lost.... Thanks again, E

Sorry if it doesn't make sense I can do this on MSAccess since I'm more familiar with it, so I apologize if I sound ignorant on this... [b]Members = fields: Userid, username ect... MessageInfo = fields: MessageID, Userid, MessageFrom, MessageTo ect... MessageText = fields: MessageID, PostText ect...[/b] Anyhow couldn't this be done: - take the MessageInfo, which has the same field "[b]MessageID[/b]", link to MessageText's "[b]MessageId[/b]" to get the "[b]PostText[/b]" - then link the MessageInfo's "[b]UserId[/b]" to the Members' "[b]UserId[/b]" to get the "[b]Username[/b]" for the "[b]MessageFrom[/b]" and "[b]MessageTo[/b]" ? that being said and if it can be done, can anyone help me figure out how to do it? Thanks, E

I have 3 tables that I am trying to query.  Members - has user info to include  (UserId, Username) MessageInfo -has (MessagetId, MessageFrom, MessageTo) MessageText - (MessageId, PostText) I want to query these together together and I'm not sure how to tie the 3 together. I can quest each individually but I'm having no success getting a query that incorporates them all.  Anyone have any suggestions? Thanks, E