Equipment Database

[bettybbm]

I am working on a equipment database that I need to keep all the service
dates in the database. I have a column titled "Date of Last Service." My
problem is when I created the form and type in the date on the form, it
replaces the previous date. I am a fairly new user. Need suggestions on how
to keep all the dates in the database. Should I create a subform? - need
direction. Please help.

 

[bettybbm]

I have separated into two related tables. However, several problems. The
equipment ID has letters in it, so must be a text. Therefore, cannot be long
integer number. Next, I created the relationship and enforced relational
integrity, but in order to create the form and subform, need to have a
one-to-many relationship don't I - Only creates a form with all fields. I
like query idea in order to sort by decending. Since linking the tables, I
now see when I open the [+] in equipment, it shows at least two lines for
service dates - which is great! Now, to create the form to input - back to
the first square? Keep me going.

 

[De Jager]

I am working on a equipment database that I need to keep all the service
dates in the database. I have a column titled "Date of Last Service." My
problem is when I created the form and type in the date on the form, it
replaces the previous date. I am a fairly new user. Need suggestions on
how
to keep all the dates in the database. Should I create a subform? - need
direction. Please help.