Strange things happen

[Pharcyde]

This I really dont understand...

Data in my tables keeps on moving around. Its like there's a poltergeist in my DB!

Let me try and explain that a little better...

Say you put in the data like

StudentID: 1 (autonumber)
name: Lee
Address: 57 Inverness Place

StudentID: 2
name: Rod
Address: 43 James Street

StudentID: 3
name: Gareth
Address: 2 City Rd


So that all looks good enough. But then for some reason, I have

StudentID: 3
name: Gareth
Address: blank

StudentID: 4
name: blank
Address: 2 City Rd


Does that make sense to anyone??

Basically I have a name field with a blank address, and then a blank name field with a repeated address . It doesnt happen to all records, just a random few.

I'll attach a copy of the DB, because I know what I said isn't very clear.

If you can help, you're officially a genius.

Cheers loads, Lee

 

[Mile-O]

Would you care to mention which tables, forms etc this phenomenon occurs in?

 

[Pharcyde]

lol, phenomenon! yeah no problem. The table is tblStudentDetails.

The form frmStuDetails, and then the subform frmStudentDetailsSubForm
which both read from the aforementioned table.

Cheers

 

[Rich]

Why do you have a form/subform based on the same table?

 

[Mile-O]

That's your problem. You have the two forms sourced by the same table. When you flick between them the record in those form are saved.

 

[Pharcyde]

Well, the main (frmStuDetails) holds all the assessment, assessment fees and personal details, etc.
I just wanted to have the student name, ID and so on at the top whilst the user could browse through the rest of the details in the tabbed panes without losing sight of who they were looking at.

Is that bad form design then?? Its an honest question, because I dont know...

 

[Pharcyde]

That's your problem. You have the two forms sourced by the same table. When you flick between them the record in those form are saved.

So its sporadically creating duplicates? that makes sense.

So i guess what I should do is hold all the students details on the main form, then keep the assessments and suchlike in the tabbed panes and it should all be ok?

Thanks guys, much appreciated

 

[Rich]

If a student can have more than one assessment then those details belong in a separate table

 

[Mile-O]

It's just that your database doesn't strike me as being normalised. Have a look at this thread in the queries section. I went to a lot of detail, I think, explaining.

 

[Pharcyde]

Brilliant, cheers for that boys. btw Rich, the assessments are in a different table, was just the student details i was having the problems with. I'll get onto the normalisation route now Mile-O