Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

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

Discussion in 'Information Technology' started by KARL DEWEY, Oct 26, 2005.

  1. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    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?


    "melwester" wrote:

    > 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 #
    >
    > "KARL DEWEY" wrote:
    >
    > > >The child is set to AutoIDNum
    > > >The Master is set to CTAName_Combo

    > >
    > > What is the relationship between these two fields?
    > >
    > > Do they contain the same data in both? Unusual that the child would be
    > > autonumber.
    > >
    > > "melwester" wrote:
    > >
    > > > Relationship has been deleted. Still doesn't work.
    > > >
    > > > "KARL DEWEY" wrote:
    > > >
    > > > > No, not as you said there were none.
    > > > >
    > > > > Check your relations. Maybe delete relation and try.
    > > > >
    > > > > "melwester" wrote:
    > > > >
    > > > > > There is nothing there. Should there be?
    > > > > >
    > > > > > "KARL DEWEY" wrote:
    > > > > >
    > > > > > > Open your table in design view and then click on menu VIEW - Indexes.
    > > > > > >
    > > > > > > See if there is an index you are not aware of.
    > > > > > >
    > > > > > > "melwester" wrote:
    > > > > > >
    > > > > > > > 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
    > > > > > > >
     
  2. Loading...


  3. melwester

    melwester
    Expand Collapse
    Guest

    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?



    "KARL DEWEY" wrote:

    > 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?
    >
    >
    > "melwester" wrote:
    >
    > > 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 #
    > >
    > > "KARL DEWEY" wrote:
    > >
    > > > >The child is set to AutoIDNum
    > > > >The Master is set to CTAName_Combo
    > > >
    > > > What is the relationship between these two fields?
    > > >
    > > > Do they contain the same data in both? Unusual that the child would be
    > > > autonumber.
    > > >
    > > > "melwester" wrote:
    > > >
    > > > > Relationship has been deleted. Still doesn't work.
    > > > >
    > > > > "KARL DEWEY" wrote:
    > > > >
    > > > > > No, not as you said there were none.
    > > > > >
    > > > > > Check your relations. Maybe delete relation and try.
    > > > > >
    > > > > > "melwester" wrote:
    > > > > >
    > > > > > > There is nothing there. Should there be?
    > > > > > >
    > > > > > > "KARL DEWEY" wrote:
    > > > > > >
    > > > > > > > Open your table in design view and then click on menu VIEW - Indexes.
    > > > > > > >
    > > > > > > > See if there is an index you are not aware of.
    > > > > > > >
    > > > > > > > "melwester" wrote:
    > > > > > > >
    > > > > > > > > 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
    > > > > > > > >
     
  4. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    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.

    "melwester" wrote:

    > 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?
    >
    >
    >
    > "KARL DEWEY" wrote:
    >
    > > 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?
    > >
    > >
    > > "melwester" wrote:
    > >
    > > > 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 #
    > > >
    > > > "KARL DEWEY" wrote:
    > > >
    > > > > >The child is set to AutoIDNum
    > > > > >The Master is set to CTAName_Combo
    > > > >
    > > > > What is the relationship between these two fields?
    > > > >
    > > > > Do they contain the same data in both? Unusual that the child would be
    > > > > autonumber.
    > > > >
    > > > > "melwester" wrote:
    > > > >
    > > > > > Relationship has been deleted. Still doesn't work.
    > > > > >
    > > > > > "KARL DEWEY" wrote:
    > > > > >
    > > > > > > No, not as you said there were none.
    > > > > > >
    > > > > > > Check your relations. Maybe delete relation and try.
    > > > > > >
    > > > > > > "melwester" wrote:
    > > > > > >
    > > > > > > > There is nothing there. Should there be?
    > > > > > > >
    > > > > > > > "KARL DEWEY" wrote:
    > > > > > > >
    > > > > > > > > Open your table in design view and then click on menu VIEW - Indexes.
    > > > > > > > >
    > > > > > > > > See if there is an index you are not aware of.
    > > > > > > > >
    > > > > > > > > "melwester" wrote:
    > > > > > > > >
    > > > > > > > > > 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
    > > > > > > > > >
     

Share This Page