4 Replies Latest reply on Feb 21, 2008 8:38 PM by (Laurence_Lewis)

    Dynamic forms from 2 tables

    (Laurence_Lewis) Level 1
      Hi, (Sorry for the long post)

      DB Table one contains 4 fields:
      EventName
      Venue
      Price
      Date

      Form one is used by the owner to enter the data for an event into the DB Table One - there are several different events.

      DB Table two contains 7 fields (4 of the fields to retrieve data from table one)
      Name
      contact
      email
      Event Name
      Venue
      Price
      Date

      Form two is for a person registering for one of the events entered into DB table one.

      -----------------------------

      I set up a recordset called rsListEvents and then used the "Insert Record Form Wizard" to create form two with the following fields:

      EventName
      Venue
      Price
      eDate

      which I set to defaults
      {rsListEvents.EventName}
      {rsListEvents.Venue}
      {rsListEvents.Price}
      {rsListEvents.eDate}

      I have a page listing the events and when register for this event is clicked I was hoping the data from table one would be entered into form two and the user then fills in the rest manually where all the data is entered into DB table two.

      Unfortunately even though the URL indicates that the correct information from table one should be entered into form two .php?id_event=2

      The data from DB table one row id_event=1 is always displayed no matter what the record number is.

      Can anyone tell me where I have gone wrong

      Thanks

      laurence