Relationship Question on one-many

[daveofgv]

Hello All -



I have been really trying to learn relationships so I can create a program in VB.NET. I think I may have it all down, however, I am still having a little confusion.

I am not sure what table (in a relationship) should be the "many side" and which should be the "one side".

For example:

I have clients that have court dates. One client can have many court dates.
Therefore, I am assuming that the relationship should be:

defendantTBL will be the "one"
CourtTable will be the "many"

"One defendant can have Many court dates" (one to many)

Is this correct???

Also, I see many people are using the primary key as the autonumber, however, it seems almost impossible to create a relationship with an autonumber. Keeps saying different values or data type when I try to connect the tables.

I don't understand foreign keys and Access 2007 (I can't find) have foreign keys, only primary keys.....

If anyone can help I appreciate it.

daveofgv

[RuralGuy]

I have clients that have court dates. One client can have many court dates.
Therefore, I am assuming that the relationship should be:

defendantTBL will be the "one"
CourtTable will be the "many"

"One defendant can have Many court dates" (one to many)

Is this correct???

The answer here is YES.

Also, I see many people are using the primary key as the autonumber, however, it seems almost impossible to create a relationship with an autonumber. Keeps saying different values or data type when I try to connect the tables.

I don't understand foreign keys and Access 2007 (I can't find) have foreign keys, only primary keys.....

The ForeignKey in the CourtTable will be a LongInteger field. The CourtTable will have its own AutoNumber PrimaryKey field.

[daveofgv]

Thanks. I think the little things like this are the most confusing (for me). I will try and see if I have any trouble.

I appreciate it again!

daveofgv