using form to update

  • Thread starter Thread starter cmichaud
  • Start date Start date
C

cmichaud

Lets say i am recording name, year, and hobby. I use a form to enter
this data. The next year rolls around and i want to add an entry for
an additional year. So i run a find, bring up the person, and change
the year. the problem i am having is that this is updating the main
record instaed of making an additional record for year. instead of
having a histroy of years i am only having one year.
this is what my tables look like currently

tblpersonalinfo
memberid
name
<etc>

tblmemberyear
memberyearID
memberID
yearID

tblYear
yearID
year

i have a few "updates" that have the will need to be made each year. i
am new to this and dont know the best way of doing it. i want to make
it as easy as possible for the person entering the info.

thanks in advance.
 
If you want to have multiple year records for a person, your year records
need to be in a sub form rather than part of the main form. You main form
should be based on tblpersonalinfo and the sub form based on tblmemberyear.
You really don't need tblYear at all.
 
Lets say i am recording name, year, and hobby. I use a form to enter
this data. The next year rolls around and i want to add an entry for
an additional year. So i run a find, bring up the person, and change
the year. the problem i am having is that this is updating the main
record instaed of making an additional record for year. instead of
having a histroy of years i am only having one year.

i have a few "updates" that have the will need to be made each year. i
am new to this and dont know the best way of doing it. i want to make
it as easy as possible for the person entering the info.
Click to expand...

Copy the record and change the year in the copy?

Keith.
www.keithwilby.com
 
Back
Top