access cannot find a record with key matching change information

[jaryszek]

Hi Guys,

my relationships:


my subform is based on query :


and if i want to write date into first column of query (Data_korekrty) and try to exit from current record on subform there is an error:
"access cannot find a record with key matching change information"



I know what is causing the problem.
Problem is connected with tbl_causes table. First i should input Cause from tbl_cause and second other fields.
How to solve the problem?

Maybe i should force user to first input data into Cause field? How to do it?
How can i solve it?

My subform child field: Korekty_ID_FK , parent field: Korekty_ID.



Please help,
Jacek

[ranman256]

you have a very hairy join.
Start with 2 tables. Test query, If that works, then join another table,
test query ,continue until you loose data. Then you found the problem.

[jaryszek]

Hi ranman256.

Process is demanding

I started with 2 tables:

tbl_causes and tbl_Daty.

Is it 1 to many relationship.

I created Qry1 in order to show you where the problem occurs.




If i am trying to input Data_korekty there is error: i have to input Cause_ID_FK and then i can input date into query.

Sample database i attached.

So user has to input first Cause_ID_Fk. How to avoid this on subform datasheetview?

Jacek

[Bulzie]

Just having relationships joining tables does not move or input data into those tables. Use the LinkMaster (put Cause_ID) and LinkChild(Cause_ID_FK) properties on subform, then when you enter the date it should also copy the Cause_ID to Cause_ID_FK.

[jaryszek]

Thank you Bulzie.

I do not know what exactly you meant.

I created sample database to show you what i want to achive.


I createa table tbl_Corrections.
And now I am creating form using this table, creating also subform from my query and linking it :
LinkMaster - ID_Korekty
LinkChild - Korekty_ID_FK

It is ok but still i have to first input into query subform Cause_ID_FK...

How can i solve this?

Thank you for your help
Jacek

[jaryszek]

Anyone please,

Jacek

[jaryszek]

Hi Guys,

i discovered very strange thing.

In my previous database i have 1 to many relationship like here:


And now result of query:


If i input clientFirstName for example NEW NAME automatically there will tblClientTypes.ClientTypeID and tblClients.ClientTypeID assigned.
Sample database in attachment.

Here in my current database i did the same query based on one to many relationship:



I added here also NEW Name (in Uwagi field - string field) and only Korekty_ID key appeared.
What about Korekty_ID_FK? Why is it no appearing? What is causing this?

thank you for your help,
warm regards,
Jacek Antek

[aytee111]

You seem to have many threads going on this subject. Remember, data must be added to records somewhere, unless you specify a default value in table design it has to be added manually, Access will not automatically put the FK value in.

[Bulzie]

You can have 2 fields in the Link lines so maybe:

LinkMaster - ID_Korekty, Cause_ID
LinkChild - Korekty_ID_FK, Cause_ID_FK

Just make sure Cause_ID along with ID_Korekty are somewhere in the main form also(if you don't want it to show make it invisible).

[jaryszek]

Thank you Guys,

i solved the problem:



I used subform and one more subsubform within subform
And now is working like a charm,

thanks !

Jacek