Hello.  I'm looking for the source to Middlegen 2.0b1 - it's not on the
downloads page.  I'm looking to debug the following issue:

I have a many-to-one relationship between table y and table x.  The foreign
key to table x from table y (x_id) happens to be part of a composite unique
index.  The value itself, however, is not unique.  When middlegen scans the
tables and creates the relationship diagram, it shows a one-to-one
relationship.  When I try to make it many-to-one (using the control-click
method) I get the following error:

"Can't change the cardinality of a one-to-one relationship where the foreign
key is also a primary key or unique."

I'm guessing that the methodology used by Middlegen to determine the
cardinality of relationships does not discriminate between unique columns
and columns that are part of a composite unique index.  Has anyone worked
around this?

If someone could point me to the source, I can look into this myself.

Thanks,
Ken


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
middlegen-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/middlegen-user

Reply via email to