Help!! Duplicate Data in a form but not in the table

[bdempsey]

Hello Everyone,
I have built a database that has 3 tables in it. Family info, Child info and account information. All 3 are separate forms and then 1 form combining the other forms. My main form with all 3 forms combined is now showing a total of over 5 thousand entries but my tables show less than a thousand. I now cannot find certain files that once previously existed.

How do i fix this?

Thanks!

[June7]

Is main form RecordSource including all 3 tables? Don't.

[bdempsey]

June7,
How do I fix this? I have multiples of the same data type in my form but not in my tables. When I run a query to see all of my records it shows the correct amount but when i go to my main form where I input things the "customer registration form" it shows the wrong amount. I have 1 main form that has subforms. Main form is the family info and then child info sub form account changes sub form and payment method subform. All of these are in 1 form.

[June7]

If each table is bound to table and not a query with multiple tables, it should work.

I would have to review database. Follow instructions at bottom of my post.

[bdempsey]

Due to confidentiality reasons I am unable to send you the file. Is there a way for me to fix it on my end?

[June7]

Of course but I can't advise how because I don't know cause.

Why don't you copy db and remove confidential stuff as already suggested?

[ssanfu]

I was going to suggest the same thing. Create a copy of the dB, delete all records, Compact and repair, then add new (made up) records.

Use people like

Herman Munster
1313 Mockingbird Lane, Mockingbird Heights, California

Lily - wife
Marilyn -niece
Eddie - son

--------------------------------------------------------

Donald Duck
1313 Webfoot Walk, Duckburg, Calisota

Daisey - wife
Huey - nephew
Dewey - nephew
Louie - nephew

--------------------------------------------------------


Homer Simpson
742 Evergreen Terrace, Johnson City, TN

Marge - wife
Lisa - daughter
Bart - son
Maggie - daughter

--------------------------------------------------------


Fred Flintstone
301 Cobblestone Wy., Bedrock, 70777

Wilma - wife
Pebbles - daughter

--------------------------------------------------------

Barney Rubble
303 Cobblestone Way, Bedrock, 70777

Betty - wife
Bam Bam - son


--------------------------------------------------------

George Jetson
1000 Skypad Apartments, Orbit City,

Jane - wife
Judy - daughter
Elroy - son




Fill in other fields with more made up data.

[orange]

Quite the family Steve!

I often deal with Polly Dacktyl and Ethyl Ether, Paige Turner, Dr. Sawitov just for mock data.

BDempsey,

Micron - has materials on randomizing "private" data -
- has provided some material re randomizing/anonymizing data for posting sample records.
- this link post#8(summarizes for ease of use)

[ArviLaanemets]

When you have x childs in family and you join family and child's tables, you get x records for this family! When you also have y different accounts for same family, and you join accounts table too, you get x*y records for this family.

When you use left join and family has no kids, all kids info for this family will be Null (i.e. according fields and controls will be empty). When you use inner join, all such families are left out from result table.

You must create a form for family info (and you can add family account info when there never will be several accounts per family). And into this family form you insert a continuous subform where kids of this family are displayed (and when family can have several accounts, then another subform where info about every family account is displayed must be added too). Subform(s) will be linked to family form through family ID.

In family form, you can have calculated controls, where some summary information from child's (and account) table(s) for active family will be displayed (like number of child's etc.).