Newbie Mayday!

[Shaun]

Hi,

I'm trying to create my first project and have spent two days and gotten
almost nowhere. I was wondering if anyone can help me. I really am only stuck
on two parts.

Background:
I am connecting my infopath form to an access relational database as my
primary data store. I have successfully created a form for users to track the
maintenance status of their vehicles (i'm in the army, we need to track
certain comunications gear). All is well (mostly) with that. Now I want to
have a summary page where they can see the total number of deficiencies by
type and i'm stuck. My database scheme is as follows (shortened for clarity)

Table: Vehicles
key
vehNumber

Table: Radio
key
keyVehicle (one-many with vehicles.key)
keyRadio (linked to radioTypes.key)

Table: RadioTypes
key
radioType

Table: Deficencies
key
keyVehicle (linked to vehicle.key)
keyRadio (liked to radio.key)
problemNote

Problem 2:
There are also tables that link the deficencies table to the types of
deficencies but you get the general idea. Now, I can't figure out how to make
a summary page which lists the different types of deficencies and sums them
up. I made a secondary data connection with the table of deficency types
being the parent table and then tried to make a repeating section but when i
tried to put a textbox in the repeating section it wanted me to bind it to a
repeating type. I don't want to do that, i just want to count how many
systems there are. I'm envisioning something like this:

------
System: Fancy Radio 1
Total Radios: X
----------
System: Fancy Radio 2
Total Radios: Y

With that as a repeating section but I can't figure out how to put the total
radios thing in. It keeps trying to get me to bind it to my data store. I'm
so confused. Please help.

Problem 2: (Probably Easy)
On my data entry page it lists all the vehicles in a repeating section.
Inside that is a repeating section to enter the types of radios (and there is
a repeating section inside that where they can put in deficiencies (each
radio can have more than one problem)). When I click "insert item" everything
pops up like it should be it also automatically inserts expands the nested
repeating section for a deficencies. Since most of the time the radio doesn't
have a problem they have to manually click "remove item". Why does it keep
showing up, no one click "insert", the other repeating sections don't
automatically insert themselves?

I'm sorry for the length. Thanks for your help.

Shaun Baker

 

[Adam Harding]

Hi

Good going so far.

To display the faults so far you need a separate view, click on views add
new view.
Then add query fields from your database that you want the users to search
on. Then add a search button that queries the database and UNDERNEATH that a
repeating section that has datafields in it that display the data you want to
the users to see (the reason it is repeating is so it can display multiple
results).

And Bob's your uncle.

Hope this helps, any questions mail me on (e-mail address removed)

cheers Adam

 

[Shaun]

okay, i'm working on that idea. I'll let you know. Any ideas on how to keep
the nested repeating table from automatically populating a single item
without me hitting "insert item"? Thanks.

Shaun

 

[Shaun]

i can't create queries from secondary datastores though, do i need to make
another form with that as the primary?