Search results for query: *

Oh, I see. Yes, that worked for the simplest queries, but when I try that method on the more complex ones that contain associations tables for many-to-many relationships, then it gives me the "ambiguous outer join" error. Is there a "read-only" setting for a query? That would be perfect...

Thanks, but the output format is fixed and there are already too many database objects. Is there any other way? Thanks. -Nathan

I should mention, to make matters worse, I'm using Office 2007 in Vista, but the end user will be using Office 2003 in XP. If necessary, I can get over to an end user's system occasionally. -Nathan

Good afternoon. I'm trying to design a system in Access that exports with minimal user interaction/brainpower, but since there are more records to export than Excel 2003 can contain, the user will have to do some copying and pasting from a query. While the user is doing that, I'd like to make...

That sounds about right. The associations tables don't have any primary keys defined, but the tblPlaces and tblEmployees do have primary keys defined as "Place Record ID" and "Employee Record ID". Those are the same field names used in the associations tables. There are no autonumber fields...

Hi. I have a database with one main table, let's say tblCompanies, which has two many-to-many relationships with other tables, tblPlaces and tblEmployees. To support the many-to-many relationships, I have two associations tables, let's say tblAssociationsCP which contains Company ID and Place...

Oh, right... Yes, I was looking to show all of the places (in the subform) related to the companies (not displayed here) that are related to a person (in the main form). That advice got me pointed in the right direction and I think I've got it working now. Thanks very much for your help!

Hi. I have a fairly complex database that I have to alter. For the purpose of this question, I'll simplify... I have the relationships between tables set up. I have a main table, tblCompanies, and two related tables, tblPeople and tblPlaces which each relate to companies in many-to-many...