I'm still having some troubles with my insurance claim entry form. I have a couple of comboboxes where users select the Account and then the Policy Number, and based on the policy they choose in that box, I have 5 text boxes that need to display some data about the policy. The text boxes are unbound because the data doesn't need to be changed on the table its coming from, or sent anywhere else because it would just be duplicate; these are just here for users to help verify that they're setting the claim up on the correct policy.
The problem I'm running into is expression syntax. Right now, I'm trying to get the insurance company's name to populate in one text box, based on the policy number the user selects. It has to jump through some hoops to get it though, and that's where I'm messing up. Basically, it goes like this:
The Company text box needs to display the Company Name found in the Entity table where the EntityID on that table matches the CompanyEntityID on the Policy table where the Policy Number matches what the user selected in the combo box.
I'm then going to have to do pretty much the same thing with the policy type, status, and term (2 date fields) boxes.
Does anyone know the syntax for that, or where to find some good examples? I tried the example on Microsoft's site, but that made the box flash #ERROR.