Guys i cant get this to work.......I need to make for each table a ID...like quoteID in the format 'Q0001'......ive did this in access.....format - \Q000....(autonumber) then when i insert new record....it does this perfect. But problem occurs when i need to reference it in another table......like Booking table. - QuoteID. It gives me not valid integer value. I tried creating an autonumber in delphi self.... but none of the code wants to work. Client wants to add a prefix coz of searching under any field. I need this for today and been struggling for days now.
Please please help