error L3002

[KevinRug]

A couple questions.
first where can I find a list of errors and their solutions?

I am getting this error when using the MENU 'database',model,errorcheck

error L3002: Child columns not specified. when I double click I get this:

"This relationship is not shown because the entities it is connected
to are not placed on the diagram."

I am fairly new to using visio as a database diagramming tool. I do not know
how to find the relationship if it is not on the diagram. How do I do this?

thanks in advance.
Kevin Ruggles

 

[Scot Becker]

Hi Kevin,

"This relationship is not shown because the entities it is
connected
to are not placed on the diagram."

I am fairly new to using visio as a database diagramming tool. I do not
know
how to find the relationship if it is not on the diagram. How do I do
this?

This is a problem with the UI whereby it is possible to drop/disconnect a
relationship, delete it, and say "no" to the prompt about deleting it from
the model. You have two options, 1) write some VBA code to find and delete
the relationship (search for a post from Chang Oh from a while back) or 2)
download the toolbox utility from my website (free) and use the element
browser to find and delete it.

HTH,
Scot.
................................................
Scot Becker

Orthogonal Software
www.orthogonalsoftware.com

ORM Blog: www.objectrolemodeling.com

To e-mail me, please use my first name at the domain listed above. All mail
sent to the reply-to address gets routed to a junk e-mail folder where it
will likely be deleted without being read.

 

[lfassio]

In emergency you can:
1. select all objects and copy in the clipboard
2. create a new blank db schema
3. paste there
4. try again validation and forward engineer

It worked for me, invisible objects are not copied in step 1 and so do not bother in step 4