> >Referential integrity rules require a related record in
> table 'Orders'.
> >
> >OK, I figure with SQL Server, you must have to populate the Order_ID
> >fields of both tables if they are related. No problem, I'll just
> >delete the relationship. So, I do that in the Diagram, but still get
> >the error. I've restarted CF and SQL, and STILL get the error.
>
> AHAH! I found it. There was an Insert and an Update trigger on the
> Line_Items.Order_ID field. I deleted them and now it works.
>
> Cool. Man, this is a whole new ballgame, eh?
This isn't actually an SQL Server issue, but rather that the Access Upsizer
creates triggers, when in SQL Server all you need is a declarative
referential integrity rule. You're generally better off not using the Access
Upsizer to create your database, but rather creating the tables yourself
with a script or the Enterprise Manager GUI, then using Access to push the
data to the server. The Upsizer doesn't set up indexes the way you'd want
them, so you might want to take a look at them as well.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
