Henryk
Posts: 63
|
| Posted: 10/26/2004, 12:07 PM |
|
Heya folks. I am trying to consider the easiest way to do a log file for inspections. I have two tables, one table is where the record for each location that is inspected is stored. This is static data which will include a serial number, location, name, etc, as well as a unique id.
The second table is a log file which stores inspection information. One of the fields will be the unique id from the location table. What I would like to do is to create a grid which searches all the location records. I could type in a name and it would search for all the locations with that name and show in my results (easy enough to here). Normally if you click on the linked field in the results it would bring up that record for editing. What I would like to do is for it to pull up that record in read only format (which is easy enough) but in addition to this also to bring back all the log table records which have the same unique id as that record does I chose from the prior form. This would show the history of inspections on that location in a seperate grid. And also on this same view would be an option to add new inspection information which would automatically put the unique id into the log record. I think the hardest part for me to figure out is how to pass the unique id into the results view of the log table on the same page and also pass it through to the new record in the log table.
Thanks
Henryk
|
 |
 |
Henryk
Posts: 63
|
| Posted: 10/29/2004, 7:52 AM |
|
No ideas? I have seen it in action on several apps made with CCS. Ultrapps is one that has a log file for ticket changes and I saw another one the other day which is like a help desk ticketing system.
Spur
|
|
|
|
peterr
Posts: 5971
|
| Posted: 10/29/2004, 2:51 PM |
|
An example of creating a log file (actually inserting records into a transaction history table) is at http://docs.codecharge.com/studio/html/ProgrammingTechn...eCustomSQL.html
Displaying such log data is usually no different than displaying the Forum messages on this page. The URL contains post_id=52804 (which could also come from a Search form) and then the grid displays matching results (Forum posts).
Not sure if this is exactly what you were asking but I hope it's close.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
