General

Re: bind combo box value to textbox

adamrharding — Fri, 12 Oct 2007 11:06:43 GMT

Hello again

First point to note, you will have to recreate your form from scratch if you now need to link it to a database, unless you are using something like QDabra Database Accelerator that allows this functionality. Make sure your tables are set out as below before starting the redesign.

You need to add a couple of fields to your CustProduct table like @PName, @UnitPrice, @Quantity and @Total, that way all the fields displayed on the form are recorded in the database. Oh, and you will need to add @GrandTotal to the Customer table.

To get this set up on the form you add the Customer table as the main table in the main data connection then add the CustProduct table linking the field CustomerID on the Customer table to CustomerID on the Cust Product table, this way, for each 1 line in Customer the form can have many lines in Cust Product.

Now you have linked in your database tables, you can redesign the form and link your repeating table to CustProduct table and delete out @CPID, @Customer ID and @Product ID from the form as the person filling in the form does not need to see these fields.

So I fill in the form now by entering my First Name into @CFName text box, my Last Name into @CLName. I then add my products into the repeating table bound to CustProduct, press submit and the @CFName, @CLName and @Customer ID are submitted to the Customer table and all the other fields are submitted to Cust Product.

Cheers

Re: bind combo box value to textbox

zolfj — Thu, 11 Oct 2007 04:27:43 GMT

Hello Adam,

I have these three tables Products(ProductID,PName,PCost),Customer(CustomerID,CFName,CLName),CustProduct(CPID,ProductID,CustomerID).

I have created a form which displays

Product Name | UnitPrice | Quantity | Total

1. abc 12 1 12

2. xyz 5 2 10

3.pqr 4 1 4

Grand Total 26

now the product name and unit price i get from the db which you told me how.now when i finish as shown above.i want to submit the form to save it in a db for a particular user.for example customer Tom

will have those product table displayed when i select tom from another form.please tell me how can i save these 3 products together when i clcik on a submit button.

cheers

zolf

Re: bind combo box value to textbox

adamrharding — Wed, 10 Oct 2007 11:24:58 GMT

zolfj

Glad to be of help.

To get this to work in a database you would have to have two tables in a one-to-many relationship with the grand total on the one side of the relationship and the values on the many side of the realtionship

For example

Master Table Daughter Table

Total Cost Cost

Name Description

Primary Key Daughter Key

etc

Then set the default value of @Total_Cost to sum(@Cost) and it will work fine.

Cheers

Re: bind combo box value to textbox

zolfj — Wed, 10 Oct 2007 04:03:25 GMT

Thanks mate,for your help.that comment of yours was to the point.i managed to get that to work.

One another question I have is now that i have this working.can i save these data in a db.i mean suppose i added three product and it also gave me the grand total.now i want to save these data in the db for a particular customer.is it possible.if yes please guide me.

appreciate your time and help.

cheers

zolf

Re: bind combo box value to textbox

adamrharding — Tue, 09 Oct 2007 08:33:09 GMT

Looking at the tutorial I happened to notice that instead of a combo box the tutorial uses the drop-down list box but having tested them both it makes no difference.

If we were following the example the specific piece of work that is causing your issue is the Rule mentioned from step 6 on.

I would perform the tasks in this order to create the effect you desire:

Select your @PName field
Click 'Rules'
Click 'Add'
Set condition to say where @PName is not blank. (later we will zero out the @UnitPrice field where @PName is blank)
Click 'Add Action'
Select 'Set a field's value'
Select the @UnitPrice field as the 'Field'
Click fx in the 'Value' box
Select 'Insert Field or Group'
Change the 'Data source' to your secondary data source
Select the field in your secondary data source that represents the unit price, maybe @Price
Now click 'Filter Data'
Then 'Add'
On the left-hand-side you want to select the field in your secondary data source that represents the @PName, maybe @Product
On the right-hand-side change the datasource back to 'Main Connection' and choose @Pname
The end result is that you have told the rule to set @UnitPrice to @Price where @Product is equal to the @Pname you have selected.
Now, for completeness add another rule on @PName where @PName is blank set @UnitPrice to 0

OK sorry that took so long but i think it should help, my statement with the above says @Price[@Product = current()] which is a shortened form of

@Price where /../@Product = current()/../@Pname

I think this is pretty exhaustive but any problems I am happy to help

Adam

Re: bind combo box value to textbox

zolfj — Tue, 09 Oct 2007 05:39:16 GMT

I tried to follow this tutorial.but the only difference is that i am using database whereas the tutorial uses XXML.but that should not make a big difference.when i preview and select a value from the combo box i get the value of the first product name in the db.then when i select any other product nothing happens.in that tutorial it had mentioned this

xdXDocument:GetDOM("Clients")/ClientInfo/Clients/Client/Name[../ID = current()]

but in my case i mean db i have this

xdXDocument:GetDOM("Product")/dfs:myFields/dfs:dataFields/d:Product/@PName

please help me.the tutorial i was following is

http://www.infopathdev.com/blogs/matt/archive/2006/04/18/Automatically-Populate-Fields-from-a-Drop_2D00_Down-Selection.aspx

Re: bind combo box value to textbox

zolfj — Tue, 09 Oct 2007 03:57:31 GMT

thanks for your comment,Kalyan

let me expalin again.

i first inserted a repeating table with 5 columns.the first column i changed it to combo box and fill it with data from the db.this first column gets the product name.which works good.now i want to be able to fill the second column with the unit price of the product selected in the combo box.but i just cant fill that column.please bear with me and help me i need that very badly.appreciate your help.

cheers

zolf

Re: bind combo box value to textbox

Kalyan Gaddam — Mon, 08 Oct 2007 12:43:28 GMT

Hello

Select the Second Repeating Table and Right click on it and select Change Binding

Select the First Repeating table in the window that Pops up and click Next

Select the field that you want to Populate and add

click OK to Save changes

I hope this will help you

bind combo box value to textbox

zolfj — Mon, 08 Oct 2007 11:31:02 GMT

hello there,

i have a repeating table with a combo box which gets its values from the db.now i want to populate other table column based on the value selected from the combo box.please guide me to do this.

thanks in advance

cheers

zolf