Hi. Here I go, playing with SQL Server again. :)
OK, I have an Access database that I've upsized. In the Access db, I
have 2 tables, Orders and Line_Items, with a related field, Order_ID
in the 2 tables. I can't really rely on sessions for this app,
because the nature of it is that the users may need to enter items
over a couple days. So... I'm writing the items to the Line_Items
table, and leaving the Order_ID field blank and adding a random
number to a temp_order field. When they come back and enter the temp
order number it searches Line_Items for that number and a NULL
Order_ID. At checkout, the line items are tallied, an Order number
generated and inserted into the 2 Order_ID fields. Great, works fine.
So, I upsize to SQL Server and when trying to enter an item, I get this error:
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.
Am I missing something? Can that relationship still be there, even
though in the diagram it says the only table related to Orders is
Customers? If so, how do I delete it? Does SQL Server just decide on
it's own that there SHOULD be a relationship because the fields are
named the same and therefore act as though there is? Should I try
deleting the relationship in the Access DB and upsize again?
Thanks.
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
------------------------------------------------------------------------------
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.
