? creating and tracking appointment

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a database that will track service calls made in the field. I
want to know how can I create a customer and track all the dates I've
serviced that customer. What i've been doing is having multiple records of
one customer. I just want certain information updated each time such as when
serviced and next service date. How can I update just this information? and
still keep track of previous service calls? Can i put in criteria to
automatically schedule an appointment so many days after it has been
serviced.

p.s.
someone tried to help me earlier but gave me sql and fk's i don't know how
to do that im trying to setup using tables in access.
 
Are you asking how to create your tables? Please tell us what you have
created so far?

Have you tried any of the Access templates?
 
Answered in microsoft.public.access

Learn to cross-post as opposed to multi-posting which you have done.
It wastes everyone's time. To cross-post just add the name of each
newsgroup in the "newsgroup" control. That assures that one response
propogates to every related newsgroup.

Read about netiquette on www.mvps.org/access

HTH
 
Back
Top