How to create an easy to use grouped query

[Mark Aslan Kuschel]

Hello,

I have to tables, companies and customer.
To each company, an indefinite number of customers can be assigned (Foreign
key).

How can I create a query that might look like this:

Firma_Name Tel Fax Email
(+) Company A Tel A Fax A Email A
(+) Company B Tel B Fax B Email B
(-) Company C Tel C Fax C Email C
Customer_Firstname Customer_Lastname Customer_Email Customer_Tel
Firstname C_1 Lastname C_1 Customermail C_1 Customertel C_1
Firstname C_2 Lastname C_2 Customermail C_2 Customertel C_2


The user clicks the plus and sees a subtable with all customers.
Is this possbile?

Best regards,
Mark Kuschel

 

[John W. Vinson]

Hello,

I have to tables, companies and customer.
To each company, an indefinite number of customers can be assigned (Foreign
key).

How can I create a query that might look like this:

Firma_Name Tel Fax Email
(+) Company A Tel A Fax A Email A
(+) Company B Tel B Fax B Email B
(-) Company C Tel C Fax C Email C
Customer_Firstname Customer_Lastname Customer_Email Customer_Tel
Firstname C_1 Lastname C_1 Customermail C_1 Customertel C_1
Firstname C_2 Lastname C_2 Customermail C_2 Customertel C_2


The user clicks the plus and sees a subtable with all customers.
Is this possbile?

Best regards,
Mark Kuschel

Sure. Don't use table datasheets.

Instead use a Form based on Companies with a Subform based on Customer.

 

[Charles Wang [MSFT]]

Hi Mark,
Currently the requirements you asked are not possiblely implemented in
Access datasheets. However John's suggestions should help. You can refer to:
http://office.microsoft.com/en-us/access/HA100986741033.aspx

May you let us know what everything is going on now? If you have any
questions or concerns, please feel free to post back.

Thank you!

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================