Error Message - Changes you requested to the table...

M

melwester

I've gotten an error message "The changes you requested to the table would
create duplicate values in the index, primary key or relationship".

The table that I'm trying to updat is allowed to have duplicate values
(MemberFID) as there are more then 1 note per MemberFID.

The child is set to AutoIDNum
The Master is set to CTAName_Combo

I don't have primary key in either table. Although the Notes table is where
this message is coming up is allowed to have duplicate values in the
MemberFID. I've tried changing the child to MemberFID but that didn't work
(didn't bring up any notes).

Here's my query:

SELECT tbl_MFMain.AutoIDNum, tbl_MFMain.MemberFID,
tbl_MemberFirmNotes.Comments, tbl_MemberFirmNotes.MNotesDate,
tbl_MemberFirmNotes.Initials, tbl_MFMain.MemberName
FROM tbl_MFMain LEFT JOIN tbl_MemberFirmNotes ON tbl_MFMain.MemberFID =
tbl_MemberFirmNotes.MemberFID
ORDER BY tbl_MemberFirmNotes.MNotesDate DESC;

I don't have no clue as to where to go from. Please help.

Thank you.

Donna
 
M

melwester

There is nothing there. Should there be?

KARL DEWEY said:
Open your table in design view and then click on menu VIEW - Indexes.

See if there is an index you are not aware of.
Click to expand...
 
K

KARL DEWEY

Open your table in design view and then click on menu VIEW - Indexes.

See if there is an index you are not aware of.
 
K

KARL DEWEY

No, not as you said there were none.

Check your relations. Maybe delete relation and try.
 
K

KARL DEWEY

The child is set to AutoIDNum
The Master is set to CTAName_Combo
Click to expand...

What is the relationship between these two fields?

Do they contain the same data in both? Unusual that the child would be
autonumber.
 
M

melwester

The relationship is 1 to 1. But the notes table could have more then 1 row
associted to the MemberFID #. I want to be able to pull in all the rows
associted with that MemberFID # that the ComboBox is showing.

The only data shown on both is the MemberFID

I've tried setting the Child to MemberFID but then it bring up the wrong
data. It is Order by qry_MFNotes.MemberFID

The AutoIDNum is the Record #
 
K

KARL DEWEY

Let me get this straight. Your child link is an autonumber field. Main
forms to sub form needs a parent (Master) to child relation. That is a
one-to-many.

If your child has an autonumber field for the link the autonumber field
records are all unique. if all records in the subform are related one-to-one
of the main form then why even have a subform?
 
M

melwester

The Child is Record Number just happened to be called AutoIDnumber.

The table of the notes has many notes for the same number (AutoIDnumber) for
exp. #301 has 4 rows of notes. Each of those rows need to be pulled into
the subform. So, yes it is 1 to many. Still learning whats 1 to 1 & 1 to
many.

Why you say to have a subform? Because it's reading from a different table
as I said there are more then 1 row per number. And yes the Notes_table is
allowed to have duplicate numbers as they are tied to the MemberFID from the
tbl_Main.

So how do I get rid of the message that is coming up?
 
K

KARL DEWEY

9I am at a loss for what to try next. I suggest you start a new post and
summarize everything you have tried.

About the only thing you have not tried is the build the tables again,
rename the old tables, append the data from the old tables, and rename the
new tables with the orignal names.

Good luck with your next post.
 
Top