InfoPath Dev

But wouldn't that prevent me from entering data into the Episode by causing a many to one relationship?

I have a list of patients that are seen at our clinic in an Access DB in a structure as follows.  demographics       insurance       episode           visit           ...

I want to set up either an SQL server or a Sharepoint server for use with an Infopath form.  I really only have two constraints, I need to be able to quickly pull and compile the data in the forms into an Excel worksheet and the form needs to be available anywhere.  I've also never set up an SQL server or a Sharepoint server, or a ...

the only way I figured out how to fix this was to completely scrap that query in access and created a new query, exact same.

when I'm writing code (I use vbscript) I often have more than one node on a single line of code. If I enter the path of the node incorrectly, and run the form, you will get an error stating: A run-time error has occurred. blah blah The following error occured: Object required: XDocument.DOM.selectSingleNode(...)' It would be splendid if ...

right, I understand that. You can use multiple scrolling regions. Scrolling Region 1 Header /***********************/ / / / Scrolling Region1 / / / /***********************/ Scrolling Region 2 Header /***********************/ / / / Scrolling Region2 / / ...

I've been having a problem with the unique filter code as stated in this thread: http://infopathdev.com/forums/topic.asp?TOPIC_ID=3506 So I came up with an idea for a work around. I created another secondary datasource that queried the Lookup datasource. It created alias fields that joined two fields. In the thread from before, it combined ...

Did you try using the 'Scrolling Region' control in the Controls Pane. Its down near the bottom under Advanced.

Thanks, but so far, I am unable to get that to work. I'm unsure of the difference between 'my:' and 'd:', and just for $h|7$ and giggles i tried @. None of the combinations worked. The only filter that did work was the unique value filter.

I have several cascading drop down boxes, all dependent on the previous selection. The problem is, the filters are not working properly. Below are what the cascading choices look like in the DB: TYPE AREA RESULTS MRI | knee | normal MRI | knee | abnormal xray | knee | normal xray | knee | abnormal this will cycle through ...