SQL Database Integration

Re: Repeating Table Dropdown

Taffman — Tue, 25 Apr 2006 14:43:36 GMT

Many thanks, should have spotted that myself ;-)

Re: Repeating Table Dropdown

Matt Faus — Tue, 25 Apr 2006 14:41:48 GMT

Yeah the forum thinks that the period at the end of the sentence should be used in the URL. Try this:

http://www.infopathdev.com/howto/tutorials/default.aspx?i=075c4e8e56db4fa5bd63615b712c0d91

Re: Repeating Table Dropdown

Taffman — Tue, 25 Apr 2006 14:29:10 GMT

This link is broken!

quote:
Originally posted by Patrick Halstead

it's probably the xpath filter when you are setting the values. There have been at least 10 posts on how to do this. You need to use the current() xpath function. Check out Greg's HowTo on cascading lists:http://www.infopathdev.com/howto/tutorials/default.aspx?i=075c4e8e56db4fa5bd63615b712c0d91.

Patrick Halstead [InfoPath MVP]
InfoPathDev

Re: Repeating Table Dropdown

Agni Jonnalagadda — Wed, 28 Sep 2005 15:38:00 GMT

Hi Drobins,
If your path is a network path and is available to all users in the network then you can can take dataconnection to that file.

Agni
InfoPath Dev India

Re: Repeating Table Dropdown

drobins — Thu, 22 Sep 2005 13:20:56 GMT

If i make an mdb database a resource file will it then be attached to the xsn where ever it gets published?

Is it possible to make a data connection to that resource file? Any examples would be great

or would i have to make the data connection first and then make the db a resource file?

Re: Repeating Table Dropdown

Patrick Halstead — Wed, 21 Sep 2005 21:58:24 GMT

Because you are running cross-domain which is only supported for full-trust solutions?

Patrick Halstead [InfoPath MVP]
InfoPathDev

Re: Repeating Table Dropdown

drobins — Wed, 21 Sep 2005 19:25:32 GMT

here is the details on the error i get:

The following DataObject either cannot be created or cannot be initialized: products
The query cannot be run for the following DataObject: products
InfoPath cannot run the specified query.
InfoPath cannot connect to the data source.
Safety settings on this computer prohibit accessing a data source on another domain.

why is this happening?

Re: Repeating Table Dropdown

drobins — Wed, 21 Sep 2005 19:14:06 GMT

I can live with a drop down box for the price.

A bigger problem now.
Once i've finished the form and i publish it then try and open this form is says a new form cannot be opened and it says it can't create a dataobject and it can't connect to the database.

do i have to have the database in the same location as the form template?

Re: Repeating Table Dropdown

drobins — Wed, 21 Sep 2005 15:08:08 GMT

ok that works fine if i want the second column to be a drop-down but i want the second column to be just a plain text field that will populate with the price after you make a selection from the drop down in the first column. I can't seem to figure out how to do that. I've tried following the same steps for populating the drop down to populate the text box but it doesn't seem to work

any suggestions would be great

Re: Repeating Table Dropdown

Patrick Halstead — Wed, 21 Sep 2005 07:16:03 GMT

it's probably the xpath filter when you are setting the values. There have been at least 10 posts on how to do this. You need to use the current() xpath function. Check out Greg's HowTo on cascading lists:http://www.infopathdev.com/howto/tutorials/default.aspx?i=075c4e8e56db4fa5bd63615b712c0d91.

Patrick Halstead [InfoPath MVP]
InfoPathDev

Re: Repeating Table Dropdown

drobins — Tue, 20 Sep 2005 18:15:07 GMT

yes it is checked

Re: Repeating Table Dropdown

vt_asparagus — Tue, 20 Sep 2005 18:06:39 GMT

The repeating table is probably bound to a group within your main datasource. When you look at the properties for that group, is the repeating checkbox checked?

Re: Repeating Table Dropdown

drobins — Tue, 20 Sep 2005 16:57:41 GMT

ok figured out how to get the price into the second column and then do the calculations for the next two fields.

Problem now is that when I add another row and make a selection from the drop down box if updates the price in the first row and not the new row.

any ideas?

Repeating Table Dropdown

drobins — Tue, 20 Sep 2005 13:33:42 GMT

I am trying to develop a form using a repeating table to be used for listing parts and their prices.

column one will be a dropdown that will list all the item codes.

When a code is selected from that list it will then populate the next column with that items price.

The user can then enter a quantity in the third column and the total will appear in the fourth column.

then to add another item the user can click the repeating table add item

I can get the list of codes to appear in first column but i can't figure out how to populate the second column with that code's price.

Does this have to be done in code?