access newbie help

[Paul]

I am new to access and am trying to develop a returned check database for my
business. I have three table that I am trying to link together so that I am
also able to view the corresponding information from whatever table I am
looking at. The three tables I have are Contact, Checks and Reference and
they all have the prefix tbl in the name.

The contents of tblContact:
ID (autonumber-Primary Key)
First Name
Last Name
Address
Apartment
City
State
Zip Code
Driver's License

Content for tblChecks:
ID (autonumber Primary Key)
Check #
Check Amount
Date
Bank Reference
Sent to Collections
Check Paid

Content of Reference:
Categories (Primary Key)

I then have ID from Contacts linked to ID from checks and if the customer
has more than one bad check, the only way for me to add that woudl be turn
off the primary key in tblChecks. I also have Bank Reference linked to
Categories from tblChecks to tblReference and that works fine. I assume that
the way I have tblContact and tblChecks is wrong since I have autonumber for
each of them and each is individual that I can't have more than one check
for each entry. How would I go about to resolve this or how should I link
the tables to get the relationships to work?

Thank you

 

[Jeff Boyce]

Paul

What are you using to link the tables together? They have to share a common
field (and an AutonumberID field does NOT count!). Since Access
independently creates an Autonumber value in EACH table you use it in, these
Autonumbers are not related to each other.

More info, please...

Jeff Boyce
<Access MVP>

 

[KARL DEWEY]

If all you are using this for is a returned check database, then either
change the CheckID to number (not autonumber). Link ContactID in a
one-to-many relation to the CheckID.

I really did not figure how you were using the Reference table.

 

[LGC]

If all you are using this for is a returned check database, then either

change the CheckID to number (not autonumber). Link ContactID in a
one-to-many relation to the CheckID.

What if a contact has more than one returned check? Just add a Contact ID
field as a foreign key to the check table and set up a one (tblContact.ID)
to many (tblChecks.ContactID) relationship.

-LGC

 

[Paul De Lagrave]

Please explain...

Do I remove the primary key abd make a new field of checkid with number
field or can I make primary with number not autonumber or if you don't mind
explaining what I would be doing

Thanks

 

[Paul]

Do I make checkid in addition to the primary (autonumber)

 

[LGC]

Do I make checkid in addition to the primary (autonumber)

Yes.

-LGC