Repeating records on a query

[turtlewick]

I created a query that combined the "Mr & Mrs" or other title with the
first name field in order to be able to print titles where appropriate
and still be okay if there were no title(for address labels). This
should have only created a recordset, its titled differently than the
original table. Now I am trying to build a simple select query to pull
b'days and anniversaries but even though I am not calling in that
recordset it seems to be getting in there anyway, causing duplicate
fields and repeating records whenever it see Mr & mrs
any ideas I have looked all thru my book for days now......help?

 

[Guest]

Are you usign subdatasheets or lookup fields at table level? I hate those
things as they can cause all types of strange behaviors.

 

[turtlewick]

Actually neither. I have 3 tables joined by a client id number. It
seems because I used a query and concatenated 2 fields, name and title,
now it pulls that in and repeats the record several times when it sees
something in the title field. Im actually trying to build a query to
feed one form three tables. So my friend will only have to input on
one form but access will actually update the data on 3 different forms.
THe book I have says you have to build a query pulling all 3 tables
in and then reference that recordset on the form.
does this m ake sense?

 

[turtlewick]

okay I have fixed the Mr/Mrs issue. After testing and reading I have
figured out the repeating records problem is happening anytime there is
more than one record for that client in the client services table.
This DB is for a B&B/SPA services business. I have 3 tables one has
name and addy, another has contact info like phones #s, email bday
annniversary and the 3rd is the service they received. This 3rd table
could have several records per client id. I have created a autonum
field in this table and made it the key. All 3 tables have client id
as a field but only the addy table and the gen info tables have the
client id as the primary key.
My goal is to bring the 3 tables together so that one input form will
update all 3 when she inputs new/modifying data. The addy file is one
client id to one address. The contact is the same. the only file
with the "many' is the services table. There are no lookups and I
have set relationships on the tables.
But lines are still repeating anytime the client gets more than one
service.

I have truly looked and tweaked till Im blue plus I have a 16 yr old
son who is more than challenging.....
please someone help
This is a favor for a friend turning repeating nightmare