Dear All,
I am very glad to be here and intent to stay .
I am new to ASP.NET, however I have managed to grasp the fundamentals ,but I have a tricky problem at hand .I am working on an application integral ASP net frame and Access database back-end .One of the requirements specification is to generate auto-number when user submit the form and I cannot get this to work . When the user submit the form they will be redirected to thankyou.aspx with a unique reference number .
I have a staff table ,reference table( primary key ref-no is set to auto number and staff_ID foreign key empty rows ) .Another table linked to reference table is faults table with part-id as foreign key from Hardware Inventory .
I have searched on Google but to no avail and I am stuck ,please help and would be grateful for any assistance rendered.