setting up lookup form

[crenshaw]

I have two tables, one table is the school lookup and the other is a program table.

School table
unitid (int)5 auto increment key
unit (varchar)5
school (varchar) 40

Program table
programid (int) 5 auto-increment key
unitid_fk (int) 5
programname (varchar) 40
startdate (date)
enddate (date)

I am joining the tables by unitid in schoool and unitid_fk in program.

The first page needs to be a form with a unit text input field. Submit needs to bring up the corresponding list from the program table that correspond to the intended unit number submitted on the form.

Can someone give me some ideas here. I may make the unit lookup pull from the table because the relationship is one to many. One unit number used many times.

Thanks

[coopster]

Welcome to WebmasterWorld, crenshaw.

What have you got so far? Have you attempted the JOIN and executed the statement?

[crenshaw]

I have the tables joined and have tested the tables to get the desired result. Whenever someone uses this site they will enter their unit and see all the rosters entered for their school.

From there I want them to create attendance for those rosters.

[coopster]

So you have the first page done where the user supplies us a value. Then, you have the second page done which lists the rosters for that user based on the value supplied. Now your next step is to create links on those rosters to either edit or delete them, but you will also need an "Add new roster" button on that screen.