What are the dependencies?
On Mon, Dec 22, 2008 at 2:05 PM, Snoopy33 <[email protected]> wrote: > > 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. > > > > > -- Charles A. Lopez [email protected] Bachelor of Arts - Computer Science New York University Registered Microsoft Partner New York City, NY
