I'm having difficulty with what seems like should be a very simple operation.
I have two tables. Orders with (simplified) fields OID with two other tables Customers with fields Cid and OrderIDFK and Locations with fields LID and OrderIDFK everything works great. If i select a customer from a drop box, the foriegn key populates in the appropriate field in the record. If i select a Location for the customer it also populates correctly. How would i go about removing the key from the LocationOrderIDFKtextbox field and reset it to Null so that the customer location shows blank? I've tried the following locationOrderIDFKtextbox.text = nothing and locationOrderIDFKtextbox.text = "DBNull" and locationOrderIDFKtextbox.text = "<DBNull>" all three momentairly remove the field. The problem is that when i save the record, goto another record, and then return, the Location FK is back in place. I'm saving using the endedit and update methods which saves data perfectly everywhere else. I'm sure that the problem is that the field is not being updated to Null because I can go into the SQL Server and copy a null field into that field and the change stays. How do i do this programatically using VB? Thanks for any help.
