This topic is locked

Select whole record via drop down or grid

8/25/2011 2:04:37 PM
PHPRunner General questions
P
philbailey author

I'm just starting with phpRunner and trying to read (and understand) as much of the manual, videos, and article as I can. I have some ideas on my project but would like some more ideas, tips, tricks, or pointing in the right direction. The biggest issue is described below.

  1. Database has three tables with two having a many - many relationship. Third table store the many - may relationships.
  2. After a new event is added(Event Table), the people table will have records added by event registrars that do not know if a person has been entered in the people table during a previous event. Most will be new people to be added, but not all will be. People table will have thousands of records.
  3. I'd to have People records matching name being entered displayed when the registrar starts typing in the name field. I see how to do that with fields, but need to display the whole record.
  4. Then, if a People record matching the current input information is displayed I'd like the registrar to be able to click on the displayed record to add the PeopleID and EventID to the People-Event table and not add the People information again to the People table.
    The point is to not enter the People information twice and be able for the registrars to select already entered people from a drop down list or another grid. Then associate the people record with the event in the People-Event table. Any ideas on this would be appreciated. Thanks. PDB
    People Table

    PeopleID1 Name Address City State Zip Email

    PeopleID2 Name Address City State Zip Email

    PeopleID3 Name Address City State Zip Email

    PeopleID4 Name Address City State Zip Email
    Event Table

    EventID1 Event Num Date Location

    EventID2 Event Num Date Location

    EventID3 Event Num Date Location

    EventID4 Event Num Date Location

    EventID5 Event Num Date Location

    EventID6 Event Num Date Location

    EventID7 Event Num Date Location
    People-Event Table

    RecID1 PeopleID1 EventID1

    RecID2 PeopleID1 EventID2

    RecID3 PeopleID1 EventID3

    RecID4 PeopleID2 EventID3

    RecID5 PeopleID3 EventID3

    RecID6 PeopleID4 EventID7

    RecID7 PeopleID5 EventID7

    RecID8 PeopleID6 EventID7