F
forest8
Hi
I have started creating a database and realize that I haven't set it up
properly.
Currently I have about 10 tables in my database. In each table, I have the
Student and Fields included. Some of these tables are currently "Students",
"Contact information" (for emergency contacts), "Needs assessment", "General
Information" (which includes address), "Courses taken".
The reason for this was that I thought I had to create individual tables to
reflect a report. By the way, I have already created some forms for this
database.
When I try to attach a Primary Key to one table and relate it to another
table, I want the actual related information to be included as the words and
not a numeric.
First, when I try to create a relationship between "Students" where the
Primary Key is their Student ID and link it to "Courses taken", I get a
Indeterminate relationship. I understand that a Student only has 1 ID number
but can take many courses.
How do I fix my database at this time?
Thank you in advance.
I have started creating a database and realize that I haven't set it up
properly.
Currently I have about 10 tables in my database. In each table, I have the
Student and Fields included. Some of these tables are currently "Students",
"Contact information" (for emergency contacts), "Needs assessment", "General
Information" (which includes address), "Courses taken".
The reason for this was that I thought I had to create individual tables to
reflect a report. By the way, I have already created some forms for this
database.
When I try to attach a Primary Key to one table and relate it to another
table, I want the actual related information to be included as the words and
not a numeric.
First, when I try to create a relationship between "Students" where the
Primary Key is their Student ID and link it to "Courses taken", I get a
Indeterminate relationship. I understand that a Student only has 1 ID number
but can take many courses.
How do I fix my database at this time?
Thank you in advance.