Remove Duplicates of 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.

I need the form to be updateable and the office
information and phone numbers are in two separate tables
and I join them by an office id.

Thanks
John
 
John,

When you say you join them by an office ID have you done that by going into
relationships and linking the fields using a one-to-many relationship?

Neil.
 
Correct

-----Original Message-----
John,

When you say you join them by an office ID have you done that by going into
relationships and linking the fields using a one-to-many relationship?

Neil.




.
Click to expand...
 
Do you have a 'main' form which contains all the office details and a sub
form (obviously in the main form) with it's linked details (link master &
link child properties) for all the telephone numbers set to match the
relationship (if sub form was created using wizard this is 'normally'
automatic)?

Neil.
 
Back
Top