TCARPENTER
Programmer
I'm having a problem with a form and subform, that I have actually been using for a while. In a subform, if I try to add a record, I'm getting the following error:
The current field must match the join key 'Tools_Table.Tools_Recnum' in the table that serves as the 'one' side of the ont-to-many relationship. Enter a record in the 'one' side table with the desired key value, and then make the entry with the desired join key in the 'many-only' table.
Here's the strange part, there is no problem with this in the tables, only in the form and only if the tool has been referenced in another location. I'm stumped. Here is my table structure:
Tools_Table
[ul]
[li]Tools_Recnum - PK - Autonumber[/li]
[li]Tools_Descr[/li]
[li]...[/li]
[/ul]
ToolsDetail_Table
[ul]
[li]ToolsDetail_Recnum - Index - Autonumber[/li]
[li]Tools_Recnum - FPK - Required: Yes (Duplicates OK)[/li]
[li]Location_Recnum - FPK - Required: Yes (Duplicates OK)[/li]
[li]Notes[/li]
[/ul]
Location_Table
[ul]
[li]Location_Recnum - Index - Autonumber[/li]
[li]Location_Address - PK[/li]
[li]Location_Descr[/li]
[li]...[/li]
[/ul]
My main form is based on my location table and my subform is based on a query which joins Tools_Table and ToolsDetail_Table.
If I add a tool that has not been referenced in the detail table before, no problem, but if the tool already exsists, I get the above error message - what am I missing?
Todd
The current field must match the join key 'Tools_Table.Tools_Recnum' in the table that serves as the 'one' side of the ont-to-many relationship. Enter a record in the 'one' side table with the desired key value, and then make the entry with the desired join key in the 'many-only' table.
Here's the strange part, there is no problem with this in the tables, only in the form and only if the tool has been referenced in another location. I'm stumped. Here is my table structure:
Tools_Table
[ul]
[li]Tools_Recnum - PK - Autonumber[/li]
[li]Tools_Descr[/li]
[li]...[/li]
[/ul]
ToolsDetail_Table
[ul]
[li]ToolsDetail_Recnum - Index - Autonumber[/li]
[li]Tools_Recnum - FPK - Required: Yes (Duplicates OK)[/li]
[li]Location_Recnum - FPK - Required: Yes (Duplicates OK)[/li]
[li]Notes[/li]
[/ul]
Location_Table
[ul]
[li]Location_Recnum - Index - Autonumber[/li]
[li]Location_Address - PK[/li]
[li]Location_Descr[/li]
[li]...[/li]
[/ul]
My main form is based on my location table and my subform is based on a query which joins Tools_Table and ToolsDetail_Table.
If I add a tool that has not been referenced in the detail table before, no problem, but if the tool already exsists, I get the above error message - what am I missing?
Todd