problem with autonumber fields

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sherry3718
    New Member
    • Jan 2007
    • 4

    #1

    problem with autonumber fields

    hi every body,
    Im Sherry, 25 years old from east. i'm beginner to microsoft access,i've designed a form in access that shows and get's the information about people. i have designed a query and selected all data needed to shown in the fileds of the form.better to say , i have multiple tables related to each other by the same ID fields.when i'm inserting a new record into the form the autonumber ID fields in one table is generated in the original table and also is written in the related field's table. but this process happned only for one pair of my tables and for the rest the autogenerated Id does not written in the related table.
    what should i do?
    anyone would help me?
  • NeoPa
    Recognized Expert Moderator MVP
    • Oct 2006
    • 32669

    #2
    To have any idea of what the problem may be we would need to understand the table structure (What they contain and how they are linked) and also we'd need to know the SQL of the Record Source of your form.
    If you can provide this information we can try to help.

    Comment

    • sherry3718
      New Member
      • Jan 2007
      • 4

      #3
      Originally posted by NeoPa
      To have any idea of what the problem may be we would need to understand the table structure (What they contain and how they are linked) and also we'd need to know the SQL of the Record Source of your form.
      If you can provide this information we can try to help.
      hi,
      thank u so much, i have found the solution of my problem : "the look up wizard" . with this data type i can guide a field to be populated with a the exact values of another table field so that two tables will be linked together.

      Comment

      • NeoPa
        Recognized Expert Moderator MVP
        • Oct 2006
        • 32669

        #4
        I'm pleased you found your answer.
        In truth, finding your own answers helps you more - but we're here to help nudge you in the right direction when we can :)

        Comment

        Working...