Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2014
    Posts
    4

    Unanswered: Insert Into SQL to many entries

    Hi all,

    I created an append query to insert data into another table based on the current entry of a specific field in the main form.
    The data is inserted into a subform.
    The problem I have is the following:
    The first time the query runs (I acnnot runit via a button but in the query section only) everything works fine.
    The second time it wirks but adds 6 instead of 2 entries. The next time 18 ... and so on. Any ideas?

    INSERT INTO sh_information ( sh_information, sh_memo, sh_from, sh_schedule, sh_type, sh_name )
    SELECT profile.profile_information, profile.profile_memo, profile.profile_from, profile.profile_schedule, profile.profile_type, q_togetthe_shname.sh_name
    FROM profile, sh_information, q_togetthe_shname;

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    how have you defiend a join betweent he 3 tables:-
    profile, sh_information, q_togetthe_shname

    how do you propose to exclude existing rows
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2014
    Posts
    4
    Thanks a lot for the reply. I attached a test db which shows exactly the problem. Perhaps you can guide me into the right direction. I tried to join the tables but nothing seems to work.
    Thanks again
    Attached Files Attached Files

  4. #4
    Join Date
    Jun 2014
    Posts
    4

    Solved

    Hi
    I found a way around. Just changed the helping sql.
    Please see attached file
    Attached Files Attached Files

Posting Permissions

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