Re: What should I set for Primary Key

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

User will import their Bank files (cleared items) to Bank table. and input
their own record (general ledger) items to Ledger table. Both tables have
same fields.

"Account #"
"Date"
"Check #"
"Amount"
"Description"
"Status"

User will run a command called "Match" and two files will run against each
other and list the ones that matches from both table, criteria based on check
# and amount.

The ones that do not match will be listed under "UnMatched"

I did some testing, and then i set the Bank table "Check #" as the primary
key,, and just let the Ledger Table have an ID primary key which doesn't do
anything for me. I dont know if i should delete it or just have a pk
assigned.

How do you set PKs for two tables with same field, and contain mostly the
same information?

Thanks.

BruceM wrote:
How is a record in one table associated with a record in another table?
Account number? If so, is the account number the primary key?
You may have heard that you can't create a relationship between two
autonumber fields, which is true for all practical purposes. I believe that
you can create a one-to-one relationship between two non-autonumber PK
fields, but your questions lead me to wonder how you go about entering data
into the two tables. Perhaps Bank and Ledger are standard terms with
specific meanings in accounting or something, but if so I am unfamiliar with
their usage. Are they intended to be identical tables that are being
reconciled by mean of double data entry, or something like that?

you can't link two primary keys, right? only primary key to foreign key,
isn't it right??
[quoted text clipped - 17 lines]
Message posted via
AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/20...

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200703/1

.

Relevant Pages

  • Re: Bank Reconciliation
    ... Column E is List 3 payments shown on bank statemnt BUT not shown on ledger ... Column F is List 4 payments shown on ledger BUT not on bank statement ...
    (microsoft.public.excel.misc)
  • Re: Bank Reconciliation
    ... Column E is List 3 payments shown on bank statemnt BUT not shown on ledger ... Column F is List 4 payments shown on ledger BUT not on bank statement ...
    (microsoft.public.excel.misc)
  • 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
    ... A primary key is something that uniquely identifies a record. ... Two tables are Bank and Ledger. ... My queries are running against both tables, such as Match Query, ...
    (microsoft.public.access.tablesdbdesign)