Entering New Recordss in a Form Based on a Query

[Venus]

I've created a student database with multiple tables that all relate to my primary table. I do not want anyone adding new student records to the primary table, so to make it as user-friendly as possible, I've created a form for entering new records. This form is based on a query that shows all the student information (from all tables) and now I find I cannot add new records. Is it possible to use a form based on a query for data entry? Or do I need to instead base the form on my primary table?

 

[plog]

Is it possible to use a form based on a query for data entry? Or do I need to instead base the form on my primary table?

Those aren't mutually exclusive questions. You can use a query, but you should use a table. What does not using the table give you? What's the purpose of using a query?

 

[Venus]

The query is nice because instead of listing the primary key in each of the different tables, it shows the text associated with it. I have a tables for the programs, majors, minors, etc. for the students. When I base the form on the primary table, it isn't very readable. Example, under major it doesn't say "Chemistry", instead it has the primary key from my Major table. It would be ideal if we had a form where we could just type "Chemistry" for a students major, instead of having to type in "3" (the primary key from the Major table).

 

[plog]

What you need to do is have a combobox for that field. Search this forum, there are many similiar questions like this asking how to display one value but use another in a drop down.

 

[Venus]

Okay, I will look into that. Thanks for your help!