Skip to main content
Participant
April 11, 2008
Question

Adding records into a database from two forms

  • April 11, 2008
  • 4 replies
  • 292 views
Hello, i have two forms, i would like to enter a record into a database using data from both forms. I have tried a simple insert query but when it comes to getting data from the second form to input into the database it says:

Element 'SMALLIMAGE' is undefined in FORM.

Any help? i mean, is there a way to uniquely identify each form so data from both can be put into the database as one record.

Thanks
    This topic has been closed for replies.

    4 replies

    BKBK
    Community Expert
    Community Expert
    April 13, 2008
    Steve.s1188 wrote:
    ... when it comes to getting data from the second form to input into the database it says:
    Element 'SMALLIMAGE' is undefined in FORM.


    Probably because the second form was not submitted. I would go for JR "Bob" Dobbs' tip. Display the fields to look like two separate forms, but use one pair of form tags and one submit button.

    Michael Borbor
    Inspiring
    April 12, 2008
    You can save the data from your 1st form into an array and then, and then on the secod form persist the data from the array and then use the array and the form data to insert into your db.
    Inspiring
    April 11, 2008
    Have you figured out a way to submit both forms?
    Inspiring
    April 11, 2008
    I suspect you will need to combine your data entry to a single form but seeing your code would be useful.