DatabaseRobert
Level 5

(I don't even have PAR module connected for TY2022, but achieve similar results in IND.)

What year are you in?  In TY2022, I no longer have a Data2 table ("dependents" in IND module, "beneficiaries" in FID, "partners" in SCO PAR COR), because they re-structured how they handled that information.  It got split out from One Big Table (for all clients, lots of records) into individual tables (one per client, only that client's records).

.

I'm using Paradox, and most of the time deal with just one client at a time--I only need to "extract all detail from all clients" so many times during the course of a year--so I go to a File Open dialog and choose the one that I want.  I am also on v.356.
 - "Client#-Detail" I am able to open just fine, and see the several columns.
 - "Client#-Detail-SubClientInfo" ("children", what used to be in the overall Data2 table) opens & I view just fine.)
 - I am completely unable to open either of "Client#-Detail-ClientStateInfo" or "Client#-Detail-SubClientStateInfo"; each of them gives me a "key violation" error when I try.

.

For "Client#-Detail-ClientStateInfo", I get these errors (each on its own screen, I just right-arrow through them), in order left-to-right, top-to-bottom:
  20230914.open failure.jpg

 

Looks like the space limitation means that I get to read the memory address in the second half of each message, and multiple fields are throwing out "issues".



Robert

0 Cheers
Reply