Automated Reference number

Question

0.00/5 (No votes)

See more:

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.

Posted 5-Mar-15 8:17am

Layman22

Updated 5-Mar-15 10:35am

v2

Add a Solution

Comments

ZurdoDev 5-Mar-15 15:41pm

What exactly is your question? To get an auto number you do what you did, set the Access field to auto number.

Layman22 5-Mar-15 16:27pm

My ASP.NET form is linked to Access database thus fault table .Fault table is linked to Reference table with RefNum set to PK auto number ,the same table has Staff_ID as foreign key from staff table .

My problem is when the user submit the form ,the button will redirect to thankyou.aspx with a unique reference number which is supposed to be generated from reference table back end access database.I cannot get this to work .

Thanks in Advance.

ZurdoDev 5-Mar-15 16:32pm

http://stackoverflow.com/questions/1628267/autonumber-value-of-last-inserted-row-ms-access-vba

Layman22 5-Mar-15 16:37pm

Many thanks I will give it go .

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)