adding event in 2nd table??

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.

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

Thanks
Love and regards
Prasad Received on Wed Oct 31 01:01:58 2007