unbound box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Russ - 01 Jul 2005 16:56 GMT

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?

Signature

Russ

Reply to this Message

Scott L. Heim [MSFT] - 01 Jul 2005 17:54 GMT

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

Reply to this Message

Russ - 01 Jul 2005 19:21 GMT

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

> Hi Russ,
>
[quoted text clipped - 16 lines]
>
> This posting is provided "AS IS" with no warranties, and confers no rights

Reply to this Message

Scott L. Heim [MSFT] - 01 Jul 2005 19:49 GMT

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

Reply to this Message