I am attempting to create a database with the following example information:
table 1
id1
name
dob (date of birth)
sex
height
weight
table 2
id2
class
class description
time
day
table 3
id3
class
class description
time
day
Table 1 will be a direct input form and is connected to table 2 via id1=id2 and table 2 is a list of classes the person is attending. Table 2 is fed by information from table 3 via dropdown box.
I know how to create the joins through the phprunner program, but I am at a loss on haow to structure the SQL query to create the correct structure to be output to a .php page that works... the one time I tried, I received errors. I would like to see the person's info at the top of the data entry page, so that I know that I am entering the class info for the correct person.
Thanks... the program is excellent, but I need to get past this sticking point before I commit to a purchase!
