Grouping

  • Thread starter Thread starter CEV
  • Start date Start date
C

CEV

Hi, I have made a form that lists people we provide services for. Under the
individuals name I have the there contact persons name. Some people have
more than one contact and for those it is showing the individuals name
several times with a different contact under each one. How can I make it
show the individuals name just once and all there contacts under there name?
I could not find any grouping option in the form properties.

Thank You,

CEV
 
The forms record source is a query called qryContactsMailingList. The query
contains the tables tblIndividuals and tblContacts. The query contains the
fields FirstName and LastName from tblIndividuals and the field Name from
tblContacts. There are additional fields in these tables, but these are the
only ones used in the query that the form is based on.

Thank You,

CEV
 
Hi CEV,

Thanks for your posting.

It seems the problem you are facing is how to display one-many relationship
in your Access forms. As Bob said, without a detailed structure, we cannot
provide too much information. For such scenario, you may consider using
subforms to complish this.

You could refer Customer Orders form in Northwind sample database of Access.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Hi CEV,

I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/

If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Back
Top