If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
? creating and tracking appointment
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. |
#2
|
|||
|
|||
? creating and tracking appointment
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? -- Duane Hookom Microsoft Access MVP "Calvin" wrote: 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. |
#3
|
|||
|
|||
? creating and tracking appointment
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 -- -Larry- -- "Calvin" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|