Hey everybody,
I a newbie to Infopath but I don't feel like it as I've been working with it for months now (version 2003 w/service pack). I've been tasked with creating some fairly complex bidding/order/invoicing forms (technically a single form with multi-views). I set it up standalone in Infopath with no data connections just fine but now that it's all laid out I have to move it over to using a MS Access database. I've done that and gotten pretty far but I've got lots of problems.
Problem 1: I can no longer attach a file or a picture. I tried using OLE object in Access but infopath kept giving me errors. Is this an Infopath/Access limitation?
Problem 2: I have repeating tables that I use for Line items which transfer from the Bid sheet to the Order sheet and finally to the Invoice Sheet ( they all load from the same Field) but when I put in my calculations, my columns won't sum. It only pulls the data from the first entry of the repeating table.
Problem 3: about said Repeating tables. I obviously want the user to be able to enter a new line item but I also have specific sections on the Order sheet(s) that are repeating so they can add multiple "details" to the whole thing. The problem comes from the nature of binding repeating objects to a Datasource or Group. Because I am only using one main data connection, a single database, it basically only gives me the option of binding to the whole thing, no matter what is actually going in that specific repeating section. So when I add extra items to the Line items section, it also adds extra Details sections of which won't fit on a page and are unecessary most of the time.
I know I'm asking a lot here, but any kind of help you guys could give me would be great. I'm pulling my hair out here.
Thanks