I build databases for law firms doing mass tort litigation. The main table is almost always something called “Clients”. I’m working on one right now in Knack. Because the Clients table is often pretty wide, I decided to separate data relating to the client’s lawsuit (case filed, etc.) from data relating to the client personally (address, phone, etc). So I created a table ClientCaseInfo and related it to Clients one-to-one.
The problem is: What does this setting mean? I was just working in the ClientCaseInfo table (where the connection above was defined) and I had no trouble creating a second case-info record for a client that already has one. I’d have expected that Knack would prevent me from doing this… Any suggestions or thoughts?