InfoPath Dev

I'm working on a form that is connected to a SQL database.  The field I'm working with is not a required, and can accept null. When I pull the record information into my form, I then want to set this field to 0.00.  I've tried setting the control in InfoPath to 0, and that didn't work.  I've also tried setting a ...

Got it working...

Also, here is a view of the relationships in the database:  

I'm working on a form with the following data source:  When I submit, I try to change the Quote QuoteStatusId (not the QuoteStatus QuoteStatusId), but it won't carry it back over to the DB.  Everything else updates, though.

Even when I'm working the in the Sales view, it opens in Manager view.

I have a form with 2 views - Manager view and Sales Rep view.  I designed the Manager view first.  I set the default view to be the Sales Rep view.  No user roles have been assigned.  Whenever I preview the form, it always opens in Manager view.  Why is this happening?

I can't get a formula I'm putting into my expression box to work. If I put it in like this xdMath:Eval(., "@Quantity - @LowestCompetitivePrice/@LowestCompetitivePrice") it works, but that's not how I want the formula to work. I want this: xdMath:Eval(., "(@Quantity - ...

Nevermind, I got it.

I am trying to do this in a form I'm working on, but I keep getting the error "does not point to a valid location path of a field or group."  I'm trying to use the Quantity and LowestCompetitivePrice fields in the LineItems group of the data source shown below.

I tried all that.  It's not giving me what I need...