Posted by Bob Stearns on 10/13/51 11:42

Aaron Reimann wrote:
> This is used for my church. We call it Communication Cards. People
> fill out the form (pen and paper) and write down info like:
>
> fname1, lname1, fname2, lname2, address1, address2
>
> and in the form there are actually checkboxes. if you want info about
> a ministry you check the box...for instance, if you want info about
> "High School" you fill out your info and check "High School." You can
> check as many as you want.
>
> We have 3 tables in the database, here are the fields in each:
> people.id, people.fname1, people.fname1, etc
> ministries.id, ministries.title
> comments.id, comments.id_people, comments.id_ministries,
> comments.comments
>
> the 3rd table, comments, "joins" people and ministires and comments
> together.
>
> $row[reople_id] (typo), it should be $row[people_id] is the people.id
>
> does that make sense?
>
What are fname2, lname2?

What does the screen contain?
Person id
ministry_id1 <checkbox1> comment1
ministry_id2 <checkbox2> comment2
ministry_id3 <checkbox3> comment3

[Back to original message]