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.
- Database has three tables with two having a many - many relationship. Third table store the many - may relationships.
- 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.
- 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.
- 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