Access 2007: Query as record source not allowing new records, HELP!

[Bevos]

Hello, I have a query as the record source of a database form in Access 2007. I've been an example of the query relationships in the attachment, but basically it is a one to many relationship between the primary key of one table, tblstudydescription, and the fk of another table, tblIntervention. The query, qryInterventionForm, works to populate the form with data that has already been entered, but I can't enter any new information. Did I set up this relationship incorrectly? Please let me know what I can do to fix this problem. I'd be happy to provide more information if needed. I've also attached an example of the database.

Thanks so much,
Bevo S.

 

[Jeanette Cunningham]

Here's a link that explains about queries that don't allow additions or edits.
http://www.allenbrowne.com/ser-61.html

 

[Jeanette Cunningham]

I have downloaded your sample database. The relationships between the tables are not correct for you to create a successful database.

In order to get a successful database, it is necessary to go back to the start and answer the question:
'What are the main entities 'things' in the data that I am working with?
You are the only person who can answer these questions and we can help along the way.

For example: what do you want the database to do? Keep in mind that most volunteers are not familiar with intervention studies in healthcare settings – you will need to explain that a bit in order for a volunteer to help successfully.

The reason your query wouldn't allow additions is the relationships between the tables are very restrictive - there are too many relationships between the main tables.

Read up on database normalization and then sit down for a couple of hours and list the entities in the data you have. Post back with your description of the entities and how they relate to each other and we can make suggestions.

While you are designing the tables, I suggest you remove those lookup fields from tblStudyDescription and put HealthcareSetting into a separate table and the same for ClinicalSetting. Avoiding lookup fields in tables will make your database much easier to work with when you are doing the queries, forms and reports.

 

[Simon_MT]

Does that mean that there many Interventions, Intervention Contexts and Outcomes fro Each Study?

Simon

 

[Jeanette Cunningham]

Please explain how interventions, contexts and outcomes work in the 'real world' of your data.
For starters, I assume that interventions are done to a 'patient' and that you would need a table of patients. I also assume that the context is somehow related to the patient.
Describe a bit about the contexts and the outcomes to help us understand.

Can a single patient have more than one intervention?
Can a single patient have more than one context?
Does the context have anything to do with the patient - is it related to the patient's lifestyle, the patient's other diseases? and what else?
I assume that the same intervention can apply to many patients?