Simple workings

[Freehal04]

So I've studied up on a lot of stuff, but I can't seem to get even the
simplest things like relationships to work. I can't have a one table
database because I'll have multiple fields with redundant data. Can anyone
point me in the right direction to help me understand how to set up
relationships that don't give me a ton of weird errors. I'm at a loss.

 

[Damian S]

Hi Freehal04,

Have tables that have an Autonumber field as the ID and primary key. When
you want to link two tables together, have a field in the second table that
is a Number field that cannot be zero, and use the Relationship manager to
join this field to the ID (autonumber) field of the related table.

eg:

tblPerson
PersonID autonumber
PersonName text
etc

tblPersonThing
PersonThingID autonumber
PersonID number <------- map this to PersonID in tblPerson
PersonThing text
etc

Hope that helps.

Damian.

 

[Freehal04]

Damian S,

How do I tell the field to be greater than 0? I'm really new at this.

 

[Damian S]

When you set up your table, in the properties for the field remove the
default value of 0.

Damian.

 

[John Vinson]

So I've studied up on a lot of stuff, but I can't seem to get even the
simplest things like relationships to work. I can't have a one table
database because I'll have multiple fields with redundant data. Can anyone
point me in the right direction to help me understand how to set up
relationships that don't give me a ton of weird errors. I'm at a loss.

What "wierd errors" are you getting?

Check out the tutorials at:

Jeff Conrad's resources page:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

especially the "Database Design 101" links on Jeff's page.

John W. Vinson[MVP]