Dear Friends,

I am having 2 tables as follow:

Table 1----->     customer_id | contacts | etc this table has unique 
customer_id while Table 2 may have more than 2 records with the same customer_id
Table 2----->     customer_id | visit_no | details of visit 

I want to know an example of updating the Table 2 with autoincrementing the 
visit_no respective to the customer_id

e.g.

Table 1
customer_id | contacts | etc 
        1001       tel. nos.    etc.
        1002       tel. nos.    etc.
        1003       tel. nos.    etc.

Table 2
customer_id | visit_no | details of visit 
        1001          1          details
        1001          2          details
        1001          3          details
        1002          1          details
        1002          2          details
        1003          1          details
        1003          2          details
        1003          3          details
        1003          4          details

Can anyone suggest an example for this type of table? or someother way of 
having the same results.
At present I can update the records in 2nd table by manually entering visit_no 
value, but one has to remember the previous visit.

Any help is appreciated.

Thanks
Love and regards
Prasad

Reply via email to