Create Relationship in access - Pls help immediately

[Raji16]

Hi,

I am a new member. i am designing a simple judicial database system. however after creating tables i am a bit confused on setting the relationships between tables :confused: here is the link of a snapshot of my table design and i wud highly appreciate if anyone cud help me on building the table relationships. Link: http://www.geocities.com/raji_mll/Relationships.JPG

The CaseID is the main primary key that links all my tables and we can have more than 1 student violation for a particular case.

thx a million,
Raj

[ashishm]

Create Primary Key on CaseId Column in CaseInformation Table

Create Foreign Key on CaseId Column in all others table

[Raji16]

Create Primary Key on CaseId Column in CaseInformation Table

Create Foreign Key on CaseId Column in all others table

Thanks Ashish for ur suggestion...
Right now i have linked all my other tables to the case info table with CaseID. but is it OK to have a relationship that has multiple tables linked to a single table's primary key? :confused:

Also,should i create separate forms for data entry and to edit existing data?

Thanks,
Raj

[ashishm]

It is OK to have a relationship that has multiple tables linked to a single table's primary key. Links depend on the requirement.

Yes, sure you can create separate forms for data entry and to edit existing data.

[lletsweletse]

You need to know your primary key entity e.g for students the primary maybe ID number,student number or make it to be an auto number in your entities.Put your cursor on the entity you want it to be the primary key then in your toolbar you will find key symbol click it,you have choosen your primary.

[lletsweletse]

You should create independant formseither by using design view or wizards for data capturing

[Raji16]

It is OK to have a relationship that has multiple tables linked to a single table's primary key. Links depend on the requirement.

Yes, sure you can create separate forms for data entry and to edit existing data.

Ashish,

Thx again for ur suggestion :) . i have a main form(case information) with a subform(Student details). i have created an undo button to undo any changes made to the form. but it can undo only changes to the main form, not in the subform. i wud appreciate if anyone can send in the code to undo events in form as well as subform at the same time??

Thx,
Raj