M
Mike Reeves
I just discovered I had Microsoft Infopath a few days ago and realized it may
work perfect for this project I am putting together. The questions I am
asking I did search for but didn't find anything. Besides, this is something
I need done quickly and if any actually knows the answers while I keep
searching, that would be great.
Thanks so much ahead of time! If I get the right answers like I hope, I'll
be sure to come back when I get started on the project ;-)
MY SCENARIO:
I'm trying to design a form that connects to a database of information.
This information through use of queries and such will need to be gathered
through a form (Infopath I assume) and queried out some more. I'll then need
to be able to manually edit any of the information and then when I'm all
done, save a "snapshot" of what I just did and print it. NOTE: When I say
edit, I do NOT mean edit the main information that was derived from MS
Access, I simply mean that particular form.
You see, we're trying to basically create a "Machine layout plan" that will
have a customer information, the item they want, the machine number and then
it will have a list of the different "parts" that we must create. These
parts have other parts in them (a belt, certain type of bolts, etc). This is
all fine and good and normally for this we would not need to make changes,
however we do have special orders come in all the time that customers want to
tweak the stuff from what our "standard" is.
SO, basically we need to be able to grab the information from a database by
using a form to determine what from the database we need, then take a
"snapshot" of that information, and then allow additions, deletions, and
updates to the current lists of information and finally, have the capability
of saving that item in a folder (preferably, though if there are better
ideas, that works too), and then printing it off and then having the
oppurtunity to go back in, print other copies off or make more changes and
save again.
BASIC QUESTIONS:
I am pretty sure Infopath is the cheapest and most likely candidate for the
job so long as the use of Access is involved, my problem are these.
1.) Will infopath be able to take a snapshot of the database information
(the queries and stuff I used to grab this unique set of information) and
save a different copy IN infopath, allow changes to be made locally to that
file? (Or maybe just some other way, I dont' know.. but our orders must each
be unique due to the high volume of special changes we get).
2.) Can infopath have a table in it full of information (such as parts) that
will be able to easily add new parts, delete old parts or change current
parts information?
3.) On top of question 2, I was thinking on creating two tables... one
called "systems", another called "systemItems" and one more called
"systemBOM" the one called "systems" would be have the titles of the
different systems we have to build for that particular machine, then drop
down another list that would be the different systemItems (like a serial
number) that make up the different systems, allowing me to choose ONE
systemItem. Finally, we would have "systemBOM" which would be our materials
list. The materials list would be connected to the systemItem and after we
had chosen the systemItem number for each system, the materials list would be
displayed underneath each system. So my question is, can this be made
possible by use of infopath and access? Also, (more of an Access question),
would it be possible to connect more than one systemItem to a system
material? (I'm assuming it would be called a many - many relationship, but we
still need to recognize that the systemItem takes precedence).
4.) Based on what you heard, do you even agree that InfoPath & Access are
the right to programs to use for this or do you have something else in mind
that I haven't thought of?
I deeply appreciate any help I get!!!
--Mike
work perfect for this project I am putting together. The questions I am
asking I did search for but didn't find anything. Besides, this is something
I need done quickly and if any actually knows the answers while I keep
searching, that would be great.
Thanks so much ahead of time! If I get the right answers like I hope, I'll
be sure to come back when I get started on the project ;-)
MY SCENARIO:
I'm trying to design a form that connects to a database of information.
This information through use of queries and such will need to be gathered
through a form (Infopath I assume) and queried out some more. I'll then need
to be able to manually edit any of the information and then when I'm all
done, save a "snapshot" of what I just did and print it. NOTE: When I say
edit, I do NOT mean edit the main information that was derived from MS
Access, I simply mean that particular form.
You see, we're trying to basically create a "Machine layout plan" that will
have a customer information, the item they want, the machine number and then
it will have a list of the different "parts" that we must create. These
parts have other parts in them (a belt, certain type of bolts, etc). This is
all fine and good and normally for this we would not need to make changes,
however we do have special orders come in all the time that customers want to
tweak the stuff from what our "standard" is.
SO, basically we need to be able to grab the information from a database by
using a form to determine what from the database we need, then take a
"snapshot" of that information, and then allow additions, deletions, and
updates to the current lists of information and finally, have the capability
of saving that item in a folder (preferably, though if there are better
ideas, that works too), and then printing it off and then having the
oppurtunity to go back in, print other copies off or make more changes and
save again.
BASIC QUESTIONS:
I am pretty sure Infopath is the cheapest and most likely candidate for the
job so long as the use of Access is involved, my problem are these.
1.) Will infopath be able to take a snapshot of the database information
(the queries and stuff I used to grab this unique set of information) and
save a different copy IN infopath, allow changes to be made locally to that
file? (Or maybe just some other way, I dont' know.. but our orders must each
be unique due to the high volume of special changes we get).
2.) Can infopath have a table in it full of information (such as parts) that
will be able to easily add new parts, delete old parts or change current
parts information?
3.) On top of question 2, I was thinking on creating two tables... one
called "systems", another called "systemItems" and one more called
"systemBOM" the one called "systems" would be have the titles of the
different systems we have to build for that particular machine, then drop
down another list that would be the different systemItems (like a serial
number) that make up the different systems, allowing me to choose ONE
systemItem. Finally, we would have "systemBOM" which would be our materials
list. The materials list would be connected to the systemItem and after we
had chosen the systemItem number for each system, the materials list would be
displayed underneath each system. So my question is, can this be made
possible by use of infopath and access? Also, (more of an Access question),
would it be possible to connect more than one systemItem to a system
material? (I'm assuming it would be called a many - many relationship, but we
still need to recognize that the systemItem takes precedence).
4.) Based on what you heard, do you even agree that InfoPath & Access are
the right to programs to use for this or do you have something else in mind
that I haven't thought of?
I deeply appreciate any help I get!!!
--Mike