Append values in java but values retrieving from database

See more:

Java

I want to append two values taking from two different tables and displays in JTextfield.

I have one enquiry textfield and another quotation textfield. so when I put 1 in enquiry, quotation become 1_1. Here 1 is enquiry and 2nd 1 is quotation..if I want to pass 3rd enquiry then quotation should become 3_2 and this 3_2 displays in quotation textfield...3rd for enquiry and 2nd number for quotation ...for 6th enquiry quotation become 6_3...so quotation is auto increment number but quotation and enuiry are two different tables.. so how to append these values? and which query I have to used ?

What I have tried:

Here I used key released action for enquiry
Please give some tricks.