M
mgleed
Hi, I'm kind of new to InfoPath. I've got several questions and I think this
could belong in at least 3 of these threads. So I hope some people will see
this.
I'm trying to create a statement form. I figured out the way to autofill
the address (from database 1) after selecting the client name in a drop-down
menu by reading an autofill tutorial on this site. But, after selecting the
client's name, I'd also like it to autofill the columns below by a link to
another database containing the date, type of work, and amount of hours I
helped them (database 2). I suspect I'd accomplish this by using a repeating
table, but I can't figure out what rules i'd assign or what script I'd write
to have it autofill. I don't think I've got the databases wrong, so I imagine
I'm making mistakes within InfoPath.
Is it possible to say, select Client A, and have all the
dates/description/hours in the database go with it, even if the client is on
multiple rows?
Despite my mishaps, I managed to figure out the formula to calculate the
taxes, client discounts, total cost, etc., but I'd like to find a way to add
up all the hours in the hours column so the total will automatically be
calculated.
And one more thing, when I enter formulae into the bottom part of the form
they don't take into account significant digits of prices. It'll say $120.2
instead of $120.20, if I can't figure out this part I don't think it'll be a
big deal, but it'd be nice.
Please help!
see images at
http://www.overheardonmyspace.com/pics/help2.gif
http://www.overheardonmyspace.com/pics/help3.gif
http://www.overheardonmyspace.com/pics/help4.gif
could belong in at least 3 of these threads. So I hope some people will see
this.
I'm trying to create a statement form. I figured out the way to autofill
the address (from database 1) after selecting the client name in a drop-down
menu by reading an autofill tutorial on this site. But, after selecting the
client's name, I'd also like it to autofill the columns below by a link to
another database containing the date, type of work, and amount of hours I
helped them (database 2). I suspect I'd accomplish this by using a repeating
table, but I can't figure out what rules i'd assign or what script I'd write
to have it autofill. I don't think I've got the databases wrong, so I imagine
I'm making mistakes within InfoPath.
Is it possible to say, select Client A, and have all the
dates/description/hours in the database go with it, even if the client is on
multiple rows?
Despite my mishaps, I managed to figure out the formula to calculate the
taxes, client discounts, total cost, etc., but I'd like to find a way to add
up all the hours in the hours column so the total will automatically be
calculated.
And one more thing, when I enter formulae into the bottom part of the form
they don't take into account significant digits of prices. It'll say $120.2
instead of $120.20, if I can't figure out this part I don't think it'll be a
big deal, but it'd be nice.
Please help!
see images at
http://www.overheardonmyspace.com/pics/help2.gif
http://www.overheardonmyspace.com/pics/help3.gif
http://www.overheardonmyspace.com/pics/help4.gif