Re: Combining (appending?) tables to form a 'new' table
- From: Vincent Johns <vjohns@xxxxxxxxxxxxxxxxxx>
- Date: Mon, 24 Oct 2005 04:19:38 GMT
jlwood44@xxxxxxxxxxx wrote:
I would like to keep an alphabetical list within each class, so I'm thinking of keeping each class. Would the other choice be a form with a subform - with the subform indicating the class, year and period?
"jlwood44@xxxxxxxxxxx" wrote:
I have imported several tables from EXCEL that are my class lists and other info. I would like to combine these lists to make a master list of my students. How can I combine the tables to a new table - and realizing that a couple of the students are listed more than once - different classes, but I (obviously) only want them listed once. I have tried appending with no results - I suppose I do not know how to. I tried earlier but was informed that I had problems with the primary key. I have changed the primary key to student ID #, but look at the situation either way. I have a field with LastName and another with FirstName.
Please be patient and be willing to walk me thru a couple of times. I tried using the Office Assistant, but have had limited/no help.
In advance, thank you very much for your help.
How do I get this combined table to be a new table?
I hope I'm not duplicating something someone else has already said, but I think you need at least 3 Tables (to support a many (students) to many (classes) relationship):
- Students (from the class lists, as I suppose you have already done)
- Classes (probably a Table with only a few fields)
- Table in which each record specifies enrollment of one student in one class
In this 3rd Table, you might have several students appearing in one class, and you might have two or more classes linked to one student. The Table might include as few as two fields per record, [StudentID] and [ClassID], though you might have reason to add others, such as grade received or date enrolled, stuff like that.
Fields in a record in the [Class] Table would relate to the class generally, nothing relating to any specific student. These could include class title, textbook used, meeting place/time, &c.
Fields in a record in the [Student] Table would relate to a student generally, not to any specific class. These could include student's first name, student ID number, stuff like that.
If you wished to record different data for some class that met in multiple years, you could have one Table for [Class], with information covering all years for that class, and another one, [ClassYear], specifying the year, a reference to the [Class], and perhaps details such as where that class met in the given year. You'd have multiple [ClassYear] records linked to one [Class] record if you do it this way.
As John Vinson pointed out, the "alphabetical" part is not something you need to worry about in the Tables -- you can do the sorting and filtering via the Queries you define. However, if you wish, you can also apply sorting and filtering to a Table to make it easier to read (and if you like the results, you can save your filter as a Query, giving it a name when you save it). But it's optional.
-- Vincent Johns <vjohns@xxxxxxxxxxxxxxxxxx> Please feel free to quote anything I say here.
.
- Prev by Date: Re: format query result
- Next by Date: Re: HELP
- Previous by thread: Re: Combining (appending?) tables to form a 'new' table
- Next by thread: trying to understand a basic query procedure
- Index(es):
Relevant Pages
|
