Apr 17 2005, 09:47 AM
Is there any way to force orphans in a child table.
The reason that i ask is that I have a table for investigation (parent) linked to a table for line (child). Now if the part is returned with no identifing marks the investigation can not conclude which line it was produced on, but if I try to exit my investigation form without completing all the controls I get the "can't find...key matching fields" error.
I have tried placing a blank entry in the child table and also removing the referential integrity but neither works.
Apr 17 2005, 10:09 AM
I had a similar problem and solved it by creating a line named unknown to be used in the situation you described.
Apr 17 2005, 10:14 AM
Brilliant! How simple was that?
Sometimes I doubt my own sanity, I think Access is to blame.
Many Thanks, this way I can preserve my integrity and the referential kind
Apr 17 2005, 10:56 AM
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here