Is there a way to get rid of Duplicates on a form

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have multiple phone numbers that relate to one office.
I do not need office information repeated, is there a way
to not show the multiple instances of the office
information in forms like there is in reports.

Thanks,
John
 
Yes, but you want to do it at the data level. Bind the form to a Group
By query - this will be exactly the same as if you used Grouping in reports.
Then of course the form becomes read only.

Pavel
 
I have multiple phone numbers that relate to one office.
I do not need office information repeated, is there a way
to not show the multiple instances of the office
information in forms like there is in reports.
Click to expand...

Certainly; several ways. One would be to use a Subform for the phone
number table so you could see the office once, with all its phone
numbers visible; another would be to base the Form on a Totals query
(not updateable, however!) grouping by all the office fields and using
First to pick an arbitrary phone number.

How is your table structured? Do you <oops!> have the office
information and the phone information in the same table, repeating the
office info with each phone, or a one-to-many relationship?
 
Nope I do not repeat information. I have one table that
stores the office information and one that stores the
phone information and I link them by an office code. In
order to put the data together I do a inner join on the
tables (one to many relationship). I need the information
to be updateable.

Thanks,
John
 
Nope I do not repeat information. I have one table that
stores the office information and one that stores the
phone information and I link them by an office code. In
order to put the data together I do a inner join on the
tables (one to many relationship). I need the information
to be updateable.
Click to expand...

Then base the Form on the office information table, and use a Subform
based on the phone table. That's the only way I can think of to have
both tables updateable and avoid repeats.
 
Back
Top