Error DAO.Recordset [3354] on new association

[ericv]

Hello,

In a data model, when I add a association between 2 tables and right-click on the link and choose "Foreign Key" then the following error is displayed  in a alert popup:

DAO.Recordset [3354] - At most one record can be returned by this subquery

After in the Foreign Key Constraint window the columns list of the table source is truncated (only   8 columns are displayed on 43) and I can't create the FK.

This problem seems concerned only one table in the schema.

The EA version is 6.5.804

Thanks for your help.
~~~
Eric

[«Midnight»]

Hi Eric,

This is potentially serious.

First, just in case it helps, try checking the integrity of your model. This will cover you if the file became corrupted somehow. Remember to do this on a copy, in case it does not solve the problem. Open you project, and from the EA main menu choose Tools | Data Management | Project Integrity Check. Follow the directions and see if you can repair the file this way.

Otherwise, if you can share your model with Sparx, I strongly suggest you zip it up (otherwise the model files tend to be quite large - something inherited from the Jet database engine) and attach it to a bug report.

More specifically, this should be a bug report directly to Sparx, rather than (just) a post to this forum - although the forum post is quite useful, particularly if you follow up with the eventual resolution.

You can reach the bug report page from the EA main menu via Help | On-line resources | Bug Report Page. You can also reach the correct page from this forum. Click the Support link at the top of any forum page, then Bug Report from the left side menu.

David