Hello, my name is Henry. I am working on creating a database to use in the
student store at my high school. Currently, our school store is managed on
paper with a page for each student's account. The students deposit money at the
beginning of the year, which is then deducted by purchases until they run out,
in which case they have to deposit more money. Due to this configuration, we
require to keep a dated running balance for each student. To follow ths
configuration, we decided to give each student his or her own table that would
keep track of their purchases and balance. However, in order to run this from a
form, we would need to have inputs that would change which table they were
assigned to based on the name of student. For example, we'd put in a student's
name and their purchase, and it would save to that student's table. However, we
do not know how to configure the tables and forms to make this work. Any
suggestions would be greatly appreciated.
Thank you for your time
Sincerely,
Henry Lewers
---------------------------------
Yahoo! Photos
Ring in the New Year with Photo Calendars. Add photos, events, holidays,
whatever.
