insert data for different people on separate rows in Access
Posted: Thu Apr 12, 2007 10:47 am
I am still relatively new to all the intricacies of PHP and am having a problem.
I have 10 different students (S1-S10) from the same school who all are given the same foods for lunch on a particular date.
They each get the same entree, condiment (like ketchup), grain, fruit, veggie1, veggie2, beverage1 and beverage2.
I need to be able to enter the amount of each item consumed (like 8 tater tots for the grain) and proportion consumed (i.e. None, 25%, 50%, 100%, other, etc.) for each student. The proportion consumed can be a drop down but it needs to allow you to type in a value if over 200%.
This data then needs to go into an Access table with each student (S1-S10) as a separate row.
Here are my Access fields in order:
schoolid (number) 1001=Burlington, 1002=CCC, 1003=Maple Woods
date (date/time)
student (number) S1=1, S2=2, S3=3 and so on
veg1 (text)
veg1amtconsumed (text)
veg1proportion (text)
veg2 (text)
veg2amtconsumed (text)
veg2proportion (text)
entree (text)
entreeamtconsumed (text)
entreeproportion (text)
condiment (text)
condimentamtconsumed (text)
condimentproportion (text)
bev1 (text)
bev1amtconsumed (text)
bev1proportion (text)
bev2 (text)
bev2amtconsumed (text)
bev2proportion (text)
grain (text)
grainamtconsumed (text)
grainproportion (text)
fruit (text)
fruitamtconsumed (text)
fruitproportion (text)
I haven't found any way to do this other than making people enter each S1's information individually on the page, then go back and enter S2's and repeat the back and forth process for all 10 students, which is a pain. Can anyone help me out with this?
I have 10 different students (S1-S10) from the same school who all are given the same foods for lunch on a particular date.
They each get the same entree, condiment (like ketchup), grain, fruit, veggie1, veggie2, beverage1 and beverage2.
I need to be able to enter the amount of each item consumed (like 8 tater tots for the grain) and proportion consumed (i.e. None, 25%, 50%, 100%, other, etc.) for each student. The proportion consumed can be a drop down but it needs to allow you to type in a value if over 200%.
This data then needs to go into an Access table with each student (S1-S10) as a separate row.
Here are my Access fields in order:
schoolid (number) 1001=Burlington, 1002=CCC, 1003=Maple Woods
date (date/time)
student (number) S1=1, S2=2, S3=3 and so on
veg1 (text)
veg1amtconsumed (text)
veg1proportion (text)
veg2 (text)
veg2amtconsumed (text)
veg2proportion (text)
entree (text)
entreeamtconsumed (text)
entreeproportion (text)
condiment (text)
condimentamtconsumed (text)
condimentproportion (text)
bev1 (text)
bev1amtconsumed (text)
bev1proportion (text)
bev2 (text)
bev2amtconsumed (text)
bev2proportion (text)
grain (text)
grainamtconsumed (text)
grainproportion (text)
fruit (text)
fruitamtconsumed (text)
fruitproportion (text)
I haven't found any way to do this other than making people enter each S1's information individually on the page, then go back and enter S2's and repeat the back and forth process for all 10 students, which is a pain. Can anyone help me out with this?