unbound box

[Russ]

Is it possible to have an unbound box in infopath?
I want to have a box that queries my access database to return the values in
field xxxx for a particular patient. there is one patient entry in the main
form but several entries in the secnd table for field xxxxx. Is this possible?

 

[Scott L. Heim [MSFT]]

Hi Russ,

Have you attempted developing your InfoPath solution directly from your
Access database? When you do, you will get both "queryFields" and
"dataFields." The queryFields allow you to specify criteria for the records
you want to return and the dataFields allow you to display/edit that data.

If you have not looked into this option the following training may be of
interest to you:

http://office.microsoft.com/en-us/training/CR061832771033.aspx

I hope this helps!

Best Regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Russ]

I did develop my InfoPath directly from Access database; I would like help in
returning the value of two or more cells from one column in the databese into
one box or other display field in InfoPath;
Sincerely, Russ

 

[Scott L. Heim [MSFT]]

Hi Russ,

I am still not 100% sure I follow what you need - if you are trying to
return multiple rows of data from one column in your Access database, then
you will need to use something like a repeating table or repeating section,
etc.

On the other hand, if you are trying to return data from multiple cells
across multiple columns (i.e. FirstName and LastName) then you could simply
create a query in Access that contains the combined field and build your
InfoPath solution from the query.

Once again - if I missed the point please provide me an example of what you
are trying to accomplish.

I hope this helps!

Best Regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.