imadsohail_at_hotmail.com (Imad) wrote in message news:<622c3496.0402290121.5321da86_at_posting.google.com>...
> I am using a weak entity of my E-R diagram as a nested table inside
> the parent entity table. Can I have that table's primary key as a
> foreign key in another table?
I believe the answer is "no", based on perusing the docs and a little
experimentation. But my experience is limited, because I would NEVER
create a nested table within a database table anyway. What would be
the point, apart from to make life difficult? Just create the weak
entity as a separate table, and (if your application prefers this) use
an object view to present the data as if it were a nested table.
Received on Mon Mar 01 2004 - 10:31:36 CST
