Data Entry In a Form Created from a Multi-Table Query 1

[ronwilliams]

I have created a form based on a query that includes fields from multiple table. The problem is that the form will not let me enter data in a new record. I have changed all properties to allow data entry and modification, deletion and additions. However, the form still will not allow me to add new records. What is the procedure to correct this error?

 

[thornmastr]

Run your query outside of your form and see if the recordset is updatable. If not, you probably have a problem in how you defined your joins. If you post your query, there are probably people here who may be able to offer you other connecting methodologies to get it to work, maybe, but you will find yourself butting up against this problem as the complexity of your database grows.

In all probability, you have designed your tables wrong and have not normalized them. You might want to take a hard look at how your tables relate and how they are defined.


Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[ronwilliams]

Thanks, I am going back and examine the table designs. I notice that my relationships table ended up will a number of copies of tables and a spiderweb of relationship links. As you hinted, that may be the root of my problem of not being able to edit the data or add records to my form created from a query that is based on multiple tables. Thanks again.

Ron Williams

 

[thornmastr]

Ron,

If you get a chance, check out a book called DATABASE DESIGN FOR MERE MORTALS by Hernandez.

It is very good with very little advanced math. Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com