Adding a table causes query data to disappear,,,

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • stonward
    New Member
    • Jun 2007
    • 145

    #1

    Adding a table causes query data to disappear,,,

    Hi Guys,

    I'm currently updating (major overhaul) a database system I built a few years ago. As part of that update, my Order Details table has several new fields: one of these is linked to a new table (one to many relationship from the new table to Order Details). When I add the new table to my query (that runs my point of sale subform) the data disappears.

    Is there a way out of this - can you see what is happening? I have joined the table in the relationships window, enforcing referential integrity.

    Thanks,

    Stonward.
  • stonward
    New Member
    • Jun 2007
    • 145

    #2
    Ah, hang on....is there a way by using sub queries? If i change the relationship type, I begin to get the data back...but so far not all the fields...

    Comment

    • MMcCarthy
      Recognized Expert MVP
      • Aug 2006
      • 14387

      #3
      Originally posted by stonward
      Ah, hang on....is there a way by using sub queries? If i change the relationship type, I begin to get the data back...but so far not all the fields...
      Forget about the forms for the moment. This is a structural / relationship problem. Look at it as a query and see how you get on.

      Also check out this tutorial for guidance.

      Database Normalisation and Table Structures

      Comment

      • stonward
        New Member
        • Jun 2007
        • 145

        #4
        Hi Mary,

        Yeah, thought I had everything at 3NF; but adding tables, and particularly fields to a system causes all sorts of troubles, eh?!

        Thanks


        R.

        Comment

        • MMcCarthy
          Recognized Expert MVP
          • Aug 2006
          • 14387

          #5
          Originally posted by stonward
          Hi Mary,

          Yeah, thought I had everything at 3NF; but adding tables, and particularly fields to a system causes all sorts of troubles, eh?!

          Thanks


          R.
          No problem. Let me know if you run into difficulties.

          Comment

          Working...