i'd use jqgrid

On Jun 25, 3:13 pm, Johann Spies <[email protected]> wrote:
> I suppose I will have to find a way to combine SQLTable and SQLForm :)
>
> Example
>
> Table A:
>
> Surname  |   Name |  School |  someotherdata...
>
> a               |       b    |    c        | ...
> d               |      e     |    f         | ...
>
> These people attend courses.  Another table (say B)  contains the
> attendance lists.
>
> What the customer wants is that when course "somecourse"  is selected
> with the purpose of filling in the attendance the form (which will
> populate table B)
>  should  be prepopulated from Table A and look like this :
>
> Course: Somecourse
>
> Teachers present:
>
> Surname  |  Name |  School | Time in              | Time out
>  a              |    b      |      c       | [to be filled in]   | [to
> be filled in]
>  d             |    e      |      f        | [to be filled in]   | [to
> be filled in]
>
> Each row in this form will be a new record in Table B. The customer
> wants the form to look like a paper form with the list of names of
> attendees thereon.
>
> Now my question:  How would you do this in the most efficient way?
>
> A Grid?
> Regards
> Johann
>
> --
> --
> "Finally, brethren, whatsoever things are true,  whatsoever things are
> honest, whatsoever things are  just, whatsoever things are pure,
> whatsoever things are lovely, whatsoever things are of good report; if
> there be any virtue, and if there be any praise, think on these
> things."    Philippians 4:8

Reply via email to