Re: access newbie

From: scott (scott_at_sporticia.com)
Date: 07/04/04

  • Next message: scott: "Re: access newbie" 
    Date: Sun, 4 Jul 2004 17:55:26 +0100

    thanks

    I have amended the 'problems' table so that the primary key is now the
    pr_number, and removed the autoincrement number field, but I'm still having
    trouble

    if I was writing this as a web page/sql backend, I would generate x2 sets of
    SQL insert statements, one into the problem table and one into the notes
    table, utilising the pr_number entered

    but Access doesn't seem to permit this (it keeps changing my SQL statements
    automatically behind the scenes??), is Access capable of inserting into x2
    tables at the same time from one entry form ?

    thanks

    _scott

    "John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
    news:bbbge05jj4c4tvd9q524682riq7u6j332t@4ax.com...
    > On Sun, 4 Jul 2004 11:14:04 +0100, "scott" <scott@sporticia.com>
    > wrote:
    >
    > >pr_index (autonumber - primary key)
    > >pr_number (unique internally assign number for this problem)
    > >pr_owner (who the problem is assigned to)
    > >pr_date (date pr opened)
    >
    > Just to add to Jeff's comment - if you have a unique, stable, reliable
    > unique internally assigned number (pr_number), it is probably a bad
    > idea to assign a formally redundant autonumber pr_index. I'd suggest
    > just making pr_number the Primary Key of this table, dropping
    > pr_index, and use pr_number as your link.
    >
    > John W. Vinson[MVP]
    > Come for live chats every Tuesday and Thursday
    > http://go.compuserve.com/msdevapps?loc=us&access=public

  • Next message: scott: "Re: access newbie"

    Relevant Pages

    • Re: DataSet and updating
      ... Autoincrement seed as 0 and the Autoincrement value to -1. ... guarantee that you and some other user don't step on each other. ... > The reason why I'm using a select statement is because I thought that I ... I have a table with a primary key being an integer. ...
      (microsoft.public.dotnet.framework.adonet)
    • SQL::Statement questions
      ... I have a file containing several SQL statements mainly ... PRIMARY KEY ... ALTER TABLE Tray ... Is SQL::Statement the appropraite module for this or is there a module ...
      (perl.dbi.users)
    • Re: DataSet and updating
      ... The refresh dataset option on the configuration wizard does this for you.. ... have you set the autoincrement property of the DataColumn to true? ... I have a table with a primary key being an integer. ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Performance effect of adding a new index
      ... If this is a table in oracle and there's really a primary key defined ... changes in the indexes for a table can potentially affect quite a few ... You need to think carefully about what SQL statements will be improved ... Along with the thoughts included above, the first question needs to be ...
      (comp.databases.oracle.server)
    • Re: Updating the correct keys
      ... > Hi Geoff, ... > Let's assume the database issues the primary keys as autoincrement values. ... > In the xsd designer, for the primary key in each table, set AutoIncrement ...
      (microsoft.public.dotnet.framework.adonet)