Table Auto Populate

[Pearse]

I have 2 tables one has 10 students and the other has 20 tasks I wish to automatically create a third table call studenttask which has 200  records with student and task fields autofilled - can Caspio do this ?

[LWSChad]

Not exactly, but you can effectively do that.

Use a view to join the tables and display all the records in one place

[Pearse]

Thanks but will this create 20 records for each student as I will need to update each of these student-task records at a later date ?