Jim If I understand your problem at all, in the underlying query make sure you drag the required fields from the two related tables on PositionID. I suppose the title you are looking for is in the Positions table; make sure this field is included in your query. All you have in the Members table is a Position field which links this table to the Positions table and contains the PositionID. The name or description of the position is in the Positions table.
If this doesn't address your problem you may have to post a copy of your database in the Files section so that members can pick it up and see where you are going wrong. Regards Liveson ----- Original Message ----- From: "Jim & Margie" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Sunday, 09 April, 2006 17:23 Subject: [ms_access] Query/Report From Multiple Tables First, let me introduce myself. I am Jim, I am a programmer by trade (mainframe, dabble in a little VB.NET). I am currently working on a MS Access database for a veterans group, and it is progressing better than I had given myself credit for. I currently have 4 sub tables, such as state, and board positions the members can hold. Ive done sub forms with combo boxes so the choice can be selected. This part works very well. The sub table for board positions is an alpha field, and has of cource the key field which is an alpha number. However, when I do a query, or even a report (board members report) i only get a number where the board position is supposed to be held. You look at the main form that holds the subform and the title correctly displays. Look at the report, or the query, or even the subform in datasheet view all you get is the number where the position title should be. Its like its indexed and thats all it wants to bring foward. I have made sure all relationships are properly established as well. I would appreciate you guidance in this. This particular report is the final thing and I am done with the project, and it is most frustrating. Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
