Repetition of data

[Cedarguy]

Hello,



I have a one to many relationship between 2 tables
All's well except the entire record on the many side repeats (as expected)
I am looking for suggestions to circumvent this problem.

Thank you

[Robeen]

Can you explain with a little more detail what you mean by:

the entire record on the many side repeats (as expected)

Is this happening in a query?

[Cedarguy]

Thank for your attention Robeen.
The one side is an enrollment; the many side is student.
A family's first enrollment creates a student(s) record(s) on the student table.
Subsequent enrollments (typical, as family renews) creates additional student records for the same student (with the new enrollment number); everything's the same on these records except for the enrollment number.
I'm beginning to realize that the relationship is faulty but not sure how to correct this,
Regards,

[Cedarguy]

Thank for your attention Robeen.
The one side is an enrollment; the many side is student.
A family's first enrollment creates a student(s) record(s) on the student table.
Subsequent enrollments (typical, as family renews) creates additional student records for the same student (with the new enrollment number); everything's the same on these records except for the enrollment number.
I'm beginning to realize that the relationship is faulty but not sure how to correct this,
Regards,

[Cedarguy]

Correction to my earlier statement "everything's the same on these records except for the enrollment number".
In addition to the enrollment number, its has a new student number. My expectation was that it would have the same student number.
Regards,

[Robeen]

Is this happening in a Form?

[Cedarguy]

Yes; when I enter a new enrollment (via a FORM), the student table that appears below it (since they're related) assigns the next autonumber to student ID which cannot be changed.
Regards,

[Robeen]

Can you give us an example of the data? A screenshot might work.

[Cedarguy]

Please see attached. The 179 you see in the ID on the student form is auto assigned and cannot be changed. It would be desirable to assign the ID of an existing student, if possible.
Regards,

[Robeen]

Could you possibly post a copy of your database here for us to look at?
You can take out sensitive data - and just strip the db down to bare essentials and a few records for us to look at to see the problem.
On what fields in the two tables have you made the relationship between the two tables?