Re: What should I set for Primary Key

A primary key is something that uniquely identifies a record. You
will have two, one in each table, but they will be the same.

Cheers,
Jason Lepack

On Mar 4, 10:29 am, "accessuser via AccessMonster.com" <u28669@uwe>
wrote:
I am trying to create an Account Reconciliation Databse which will compare
two tables. Two tables are Bank and Ledger. Both tables have same fields.
Users will import bank file to bank table and general ledger file to ledger
table. Since both tables haave the same fields, what should I do with
Primary key? My queries are running against both tables, such as Match Query,
UnMatched Query. Suggestions?

Thank you.

--
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/20...


.

Relevant Pages

  • What should I set for Primary Key
    ... Two tables are Bank and Ledger. ... Users will import bank file to bank table and general ledger file to ledger ... My queries are running against both tables, such as Match Query, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: What should I set for Primary Key
    ... User will import their Bank files (cleared items) to Bank table. ... their own record (general ledger) items to Ledger table. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Sequence of columns in primary key
    ... Ledger is likely to have a maximum of ... OrderNumber a maximum of 10 million and OrderLine up ... the order in a primary key should rather reflect the logical ... CONSTRAINT pk_bho PRIMARY KEY (coucode, ...
    (comp.databases.ms-sqlserver)
  • Re: Help me design a table
    ... that will be read by a 3rd party product which allows little ... id - primary key ... bank - non null ) ... Because it isn't Oracle either. ...
    (comp.databases.oracle.server)
  • Re: Sequence of columns in primary key
    ... > most likely filtering on OrderLines is by Ledger and OrderNumber, ... > two should come before OrderLineNumber in the primary key. ... The key reorder certainly gave a drastic relief on the poor index. ... Or at least scan for a Ledger. ...
    (comp.databases.ms-sqlserver)