Your database design is a lot closer to what I was expecting. Please note that my original design included course sections in case there were different sections for each course; if you don't need to...

How do you plan to record the grade a student has for each of his/her classes? What is the difference between class and course?

I feel a lot of your relationships are backwards. For example,...

How does your design track which classes the grades are for? How does your design track each assignment? Is each major a part of a field? What do the penalty and class tables track? How does your...

I gave you the tables I would use for this database above. As far as the relationships:

course-section: one-to-many
section-enrollment: one-to-many
section-assignment: one-to-many...

You can join the grade table to the section table and then join that to the course table. If you need to track a subject, you can add a subject table and have a foreign key in the course table to...

Below is the database structure I would start with:

Student: ID, Last Name, First Name, etc
Course: ID, Course Name
Section: ID, Course ID, Section Name
Enrollment: ID, Section ID, Student ID...

Are you familiar with VBA? If so, the code you need should be something along the lines of this:


Private Sub Combo182_Change()
Combo183.rowsource = "SELECT Models.[Model Name] FROM Models...

What I had in mind was to use the On Change event of Combo182 to update the Row Source of the Model combo box.

From your post, it sounded as if you used the table directly to enter and view data. I would recommend that you use a form to modify and view the data.

With the form, you can add a make combo box...

Try creating the following three queries. If you use a name other than the ones I provide, then you will need to update the last query to refer to the names you used for the first two.

Query1:...

Can you tell me what the fields in each of the tables are and what the table d contains?

It seems like the issue you are having is that is that your join is creating an instance where each record...

I would recommend the "lookup table" approach. This will save you from creating many tables that serve the same purpose and it will make queries easier to build since you don't have to remember...

I would say that the number of fields in a table has very little impact on database performance. I don't think you will notice a difference between the query speed of a table with just a few fields...

Since the relationship between the tables is a one-to-many relationship, you do not need an intermediate table. You only need to have the following structure:

County: ID (PK), Name, etc.
Voting...

From what you described, it sounds like the VLOOKUP function will work.

You give VLOOKUP a value, a range and a return column. The function will then look for the value in the range and then...

I'm thinking that having three entities may be the way to go to keep things not overly complex while keeping things flexible too:

Company: ID (PK)
Property Type: ID, Description, Data Type,...

If the properties you are referring to apply to each record, then you can add them as fields (columns). For example, if you are tracking products you are selling, then a height, width, length and...

I would go with something similar to option 2. Option 1 would not be a noramalized database design, so I would stay away from it.

I see you requiring three entities:
1) Company Entity
2)...

Try this:


SQLText = "INSERT INTO issues1 ([title], [time], [Opened], [opened by], [staff], [status], [category], [comment], [assigned to]) SELECT [title], [time], [Opened], [opened by], [staff],...

Can you show us the statement that doesn't work? My first guess would be that you don't have brackets around each of the fields. I see you have brackets in the Insert INTO section of the SQL...

From what I can make from your description and table names, here are the fields I would use:

GuestTicket: ID, GuestTicketType (FK), Name, etc
GuestTicketOrder: ID, GuestTicket (FK),...

With the form in design view, go to View, Tab Order. You can then click and drag items in the order you want the user to tab in or click Auto Order.

Do you have that code on a line all by itself? You need to add the 'SQLTEXT =' to the beginning of the line.

View the attached picture to see exactly what it should look like. The Me.Id refers...

You are correct... I overlooked the word 'issues' in the SQL statement.

You should be able to replace 'helpdeskLogTable issues' with isses1

You mentioned you linked the two tables. Wasn't...

Two issues:

1) I don't think you can update a table that is not in the database. I think you need to create a linked table. To do so, click on File, Get External Data, Link tables. Then browse...

Are you familiar with both VBA and SQL? If so, then you can see how to run an append query from VBA at this site:

http://www.blueclaw-db.com/docmd_runsql_example.htm

Specifically, look at this...

I would recommend adding a button on the form and setting its visibility to false. Then on the AfterUpdate event of the form, make the button visible. Lastly, if someone clicks the button, have the...

Here is the SQL for what you are trying to do in one query:


SELECT Sum(Count) AS SUMofLessonsAndTests
FROM
(
SELECT count(lessons.lesson_date) AS Count
FROM lessons
WHERE...

There are several things wrong with the query.

1) You have quotes on either side of the &. They are not needed since you are looking for the string "Examiner & Instructor"
2) In the Instructor...

You still need a Student/Module table and tables to deal with the prerequisites.

What is the difference between the lecture entity and the session entity; isn't a lecture just a type of session? Same with practical session and session.

I see you removed the relationship...

Okay, I read the original assignment and drew an ER Diagram based on the assignment. After drawing the ER Diagram, I counted the number of tables required and came up with 18 tables.

There are...

What attributes will be in the academic record entity? Since you will have a credits earned attribute in the studies entity, I was thinking you could get rid of the academic records entity.
...

Instead of using the instruct_examiner table, I would recommend that you just add a record to the examiner table and one in the instructor table. People that appear in both tables are people who are...

1) The way you have your ER Diagram drawn, each studies record will have a course foreign key. From the course entity, you can find out which student is associated with the studies record. In...

Thank you for the attachment. Do you have any specific questions on how to build the queries you need? I don't mind helping, but I don't want to do the assignment for you.

Secondly, in your...

Your current ER Diagram is a good start, but let me ask you some questions that may make you want to change your diagram a little:

1) How can you track if a student wants to take a module that is...

Attached is the ER Diagram I would use. Please notice that any person is able to be a student, instructor, examiner or any combination of the three. Also note that my diagram does not include...

I reviewed the E-R Diagram and it is a good start.

I'm not sure a booking entity is needed as long as you have a booking date attribute in the test and lesson entities.

What is the Test Type...

There are three types of people:
Students, Instructors and Examiners.

I was suggesting that you use a people entity to track the name, address, phone number, etc. of all the people you record,...