By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,852 Members | 994 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,852 IT Pros & Developers. It's quick & easy.

Create Relationship in access - Pls help immediately

P: 3
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
Mar 10 '06 #1
Share this Question
Share on Google+
6 Replies


P: 13
Create Primary Key on CaseId Column in CaseInformation Table

Create Foreign Key on CaseId Column in all others table
Mar 11 '06 #2

P: 3
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
Mar 13 '06 #3

P: 13
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.
Mar 14 '06 #4

P: 4
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.
Mar 14 '06 #5

P: 4
You should create independant formseither by using design view or wizards for data capturing
Mar 14 '06 #6

P: 3
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
Mar 15 '06 #7

Post your reply

Sign in to post your reply or Sign up for a free account.