I just received a mess.
They admit it and are willing to do whatever it takes to fix.

they have 4 tables and they entered the data in the tables, they have
no forms.

each table is a different set of data for the same people
they used an autoid and set it to a primary key, not sure why, but
they did this in each table.

so they had
table 1
autoid 1 bob jones
table 2
autoid 1 bob jones
table 3
autoid 1 bob jones

they all match id and name until you get to table 4

in table 4 its multi records for the same people

autoid 1 bob jones
autoid 2 bob jones
autoid 3 jim smith
autoid 4 jim smith


I made a table demographics and put their main identifiers in here
I can link this to table 1 2 3 all works fine.
Now to table 4

is there a way to get table 4 structured to work as a 1 to many with
the new tbldemographics?

I can't think of any way to get table 4 to work but I wanted to ask
before going to any extremes like re entering the data.

thanks for any ideas

I wanted to ad something

tables 1 2 & 3 all have 153 record and they all match...God only knows
how

table 4 has 296 records being mulable records for some of these
people..it does have at least 1 record for each of the 153 records
contrained in the other tables. There are not any records that are not
found in the others.



On Tue, 31 Mar 2009 13:10:35 GMT, sparks <sparks (AT) comcast (DOT) net> wrote:

sparks wrote:
Excellente`