Re: Multiuser record lock query?

From: Gitendra Proctor (gproctor_at_ihug.com.au)
Date: 03/30/04 

Date: Mon, 29 Mar 2004 16:01:11 -0800

Hi!
I am unfamilier with the term "Identity column", I looked up the documentation and as I understand it is much like the autonumber feature in MS ACCESS. I have used the autonumber (identity column) feature, when I wanted an unique sequentially incremented number for one table.

Here I have multiple tables, and I need a single unique sequential number (It's a docket number) each time a record is added to any of the tables.

Please let me know if this is the right interpretation of "Identity Column". Thankyou for taking the time to answer my query.

Regards
Gitendra

Relevant Pages

  • Re: Basic SQL
    ... John Gilson wrote: ... have multiple values for column b, but cannot figure it out - can someone help? ... Regards ... Given the original poster's stated input and required output, your query doesn't ...
    (comp.databases)
  • Re: Basic SQL
    ... John Gilson wrote: ... have multiple values for column b, but cannot figure it out - can someone help? ... The results of the query when running against the above data ... Regards ...
    (comp.databases)
  • multiple table results as one table in dataset
    ... I have a problem in returning data from multiple table as one table into ... as we know that in dataset we can populate it with multiple tables, ... i want the result of a following query which is coming from multiple ...
    (microsoft.public.vb.database.ado)
  • RE: Loops
    ... table with multiple columns 5 for each pay period, ... I run my query for the pay period ending on 01/05/07 ... you are updating multiple tables. ...
    (microsoft.public.access.modulesdaovba)
  • RE: Form For Crosstab Query
    ... My next step is to place the query on a continuour form, and add a command ... FROM (TimeRecords INNER JOIN Staff ON TimeRecords.StaffID = Staff.StaffID) ... I would like to add an additional column that sums the multiple of each ...
    (microsoft.public.access.forms)