adding multiple child records

Ask a Question related to Dreamweaver AppDev, Design and Development.

  1. #1

    Default adding multiple child records

    i have an access database set up with 2 tables: tblContacts, and tblNotes
    tblNotes is related to tblContacts by a field caled ContactID

    i have implimented the ability to add new contacts to the database and it
    works great.
    my problem is with my add note page: addnote.aspx

    when adding a new note the url parameter is set to the ContactID of that
    member in
    the Contact Table: addnote.aspx?ContactID=1234

    this of course adds the note to the parent contact. however it will let me add
    another one.
    when trying to add a second note to the same contact
    addnote.aspx?ContactID=1234 it fills the form fields automatically with the
    previous note fields.

    i do see why it is doing this, but what i don't understand is how to make my
    form realize i am trying to add another note not update my previous one.

    any help?

    acidrain9 Guest

  2. Similar Questions and Discussions

    1. Simple question: show child records as opposed to link
      Hi I have a datagrid (VS2003 and framework 1.1). The grid is bound to 2 tables (parent child etc.). Does anyone know if its possible to show...
    2. update multiple records in multiple tables from one form
      hello I have been trying to run multiple update queries based on the data entered by user. Brief background: I am fetching data from various...
    3. SQL: Deleting child records recursively
      I have a table of records that share a parent/child relationship. Ie: id | parentID | item 1 | 0 | main item 2 | 1 | secondary...
    4. adding multiple records
      Thanks Perry, I am not sure what : (" & (nBsae £« 1£ > © & " )") is as the characters are not normal? could you please repost, thank...
    5. Subform listbox records don't reflect master/child link
      "Nick Mirro" <nickmirro@attbi.com> wrote: Nick, you have to update the list box when navigating through the main form. You can do this in...
  3. #2

    Default Re: adding multiple child records

    i figured out what i was doing wrong, i had each textbox's text linked to the same filed in the database, works fine now
    acidrain9 Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139