This recordset not updateable (no join between tables in query)

[Drutski]

I've managed to solve a lot of problems in my database on discovering subqueries. Now I've got and input form based on a table with a subform based on a cascading set of subqueries. This all works fine until I have to define the relationship between my subqueries in the query field criteria. I am looking up the values for [PSCNQNWindowNumber] on the [tblPSCNQNWindowNumbers] table where the [PlannedEndDate] field on the [LearnerAimsQuals] query is between [fldPSCNQNWindowStartDate] And [fldPSCNQNWindowEndDate] on the [tblPSCNQNWindowNumbers] table. The query criteria works in retrieving the correct data which I have then gone on to use to define further relationships in further working subqueries.

The problem is that there is no clear defined relationship as far as access is concerned and as a result I cannot edit the data in the query. I've attached a copy of the database to clarify. The problem arises in the LearnerAimsQualsWindows query.

 

[JHB]

None of the queries return any data, (missing data in the tables), so ...!

 

[Drutski]

Oops, I pulled all the data out of the tables to post the database for data protection reasons. The queries return exactly the data I want, the problem arises in my chain of queries when it comes to looking up the data from the qualifications table. I need to figure out a way of joining those tables but there is no logical way of putting a foreign key from the [tblPSCNQNWindowNumbers] to the [LearnerAimsQuals] as it is the criteria of the [PlannedEndDate] that determines the relationship.

 

[JHB]

Oops, I pulled all the data out of the tables to post the database for data protection reasons.

Ohh - then luck with your project.

 

[Drutski]

Wow, passive aggressive. If you had nothing constructive to add it would have been better just to not reply. Good luck with your life.

 

[spikepl]

So you decided to lead by example, and bitch about someone deciding not to volunteer any more efforts on your behalf?

If you had nothing constructive to add it would have been better just to not reply.

Agreed. Heed you own advice.

 

[Brianwarnock]

When will posters realise that we are not mind readers or miracle workers, we need something meaningful to work with.

As an old timer I'm appalled as to how much development is done on live data and thus there is nothing to show the helpers or it is too big to post.

How can you effectively check huge amounts of data?
How can you be sure that random data, ie live, ticks all the boxes that need testing?

Brian