×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

New Database Stuck in Queries, Numbering & Duplicate Names

New Database Stuck in Queries, Numbering & Duplicate Names

New Database Stuck in Queries, Numbering & Duplicate Names

(OP)
I am trying to help the local Ombudsman office here with a database. I am new to database design. I am using a program called Brilliant database Design. I have the database set up already but my numbering is a problem. I have added 15 enteries so far, have deleted all of them, but if i try to add a new entry it will start at 16 and not at 1 seeing that i deleted all. What can I do? I also need some help with queries so I can bring up the amount of cases for the month, Amount of cases by district and query my first or last name. I also have a section on the form for a signature that will be gotten by jpeg from scanner  but need it to remain visible when i am printing the form. I am really trying to help this no-profit organization . Please advice me on how to get this completed.

RE: New Database Stuck in Queries, Numbering & Duplicate Names

The numbering issue sounds like an Autonumber field in Access and that is how it works. Its only purpose is (or should be) to provide a unique value. You should not treat Autonumber fields (AKA Identity fields) as having meaning beyond being merely unique.

If you need meaningful numbers then there are ways to generate them but those are dependent upon the DBMS / Language that you are using.

Without some knowledge of your tables we really can't provide very specific advice about what your SQL needs to be to get the results that you want.

You will probably get better answers if you ask those questions in one of the forums specific to the DBMS that you are using rather than this forum on General Database Discussions.

RE: New Database Stuck in Queries, Numbering & Duplicate Names

If you are new to database start with this: http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx

If your data is not structured well, everything you do later will be more difficult.

Jeff
It's never too early to begin preparing for International Talk Like a Pirate Day
"The software I buy sucks,  The software I write sucks.  It's time to give up and have a beer..." - Me

RE: New Database Stuck in Queries, Numbering & Duplicate Names




Hi,

This is probably an AutoNumber Key value.  It should not be significant to your process.  It is designed to provide a unique key value for that table.

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: New Database Stuck in Queries, Numbering & Duplicate Names

That is exactly what it should do to maintain data integrity. This is by design. YOu should never rely on numbers to be in order with no gaps as no database will do that without alot of potentially hazardous workarounds.  THe surrogate key is just that a meaningless number that is used to link to other tables and to identify the record uniquely. It should have no other meaning (although users certainly can see it because it is easier to talk about work order 134 than to try to give it a name)

If they want you to have records without gaps, tell tham that is a very bad idea and will create more problems than it solves.

"NOTHING is more important in a database than integrity." ESquared
 

RE: New Database Stuck in Queries, Numbering & Duplicate Names

Gary,

forms are nothing to do with the database design and the numbering of primary keys.

We can help you with database design, discuss surrogacy until the sun goes dark, and eulogise about normalisation.  However, nobody here (probably) can know the specifics of a particular form in a particular piece of software.

Is your issue with the database or the form you're struggling with.  If the latter, you'll have to provide information about what software you're using etc.

Please bear in mind that we can't see what you can, and we don't know what you do.  You have to give us enough information to be able to meaningfully help you.

Regards

T

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close