I need to design a database that will allow for some assistance with audits.
I am considering the following, but would appreciate any help and guidance
from you all!

My first stage is to design a form that will allow the user to input data as
is recorded in some notes as well as the same data fields that should have
been entered. Once entered, this data then needs to be run through some
software (via some SQL script with .exe prompts to ensure it's as automated
as possible). The data will then hopefully be outputted on a report,
summarising the data that was held within the notes and the data that should
have been recorded (including output fields from the software).

I am therefore considering designing the database as follows.

Create two tables (one for the notes data and one for the actual data).
A form is created allowing user input that will dump this data into the two
tables.
These two tables are then exported and run through the software and two new
tables created including the relevant software output fields.
I then need to write a report to show all data fields (one set for the data
held within the notes and one set for the acutal data and the corresponding
outputs from the software).

Looking for guidance/advice and how best to design. Appreciate it all sounds
a bit vague, but happy to answer questions that people have!!!

Many thanks

Is this really a Frontpage question?

Try Microsoft.Public.Access (if you use MS Access as your DB).

Looks like it belongs in an Access group (or if there's no such group,
apologies in advance, if you've posted here because there's no alternative
group).

"Andy" <(E-Mail Removed)> wrote in message
news2D36C57-9643-4050-8382-(E-Mail Removed)...
>I need to design a database that will allow for some assistance with
>audits.
> I am considering the following, but would appreciate any help and guidance
> from you all!
>
> My first stage is to design a form that will allow the user to input data
> as
> is recorded in some notes as well as the same data fields that should have
> been entered. Once entered, this data then needs to be run through some
> software (via some SQL script with .exe prompts to ensure it's as
> automated
> as possible). The data will then hopefully be outputted on a report,
> summarising the data that was held within the notes and the data that
> should
> have been recorded (including output fields from the software).
>
> I am therefore considering designing the database as follows.
>
> Create two tables (one for the notes data and one for the actual data).
> A form is created allowing user input that will dump this data into the
> two
> tables.
> These two tables are then exported and run through the software and two
> new
> tables created including the relevant software output fields.
> I then need to write a report to show all data fields (one set for the
> data
> held within the notes and one set for the acutal data and the
> corresponding
> outputs from the software).
>
> Looking for guidance/advice and how best to design. Appreciate it all
> sounds
> a bit vague, but happy to answer questions that people have!!!
>
> Many thanks

Can all be done w/ FP, SQL and a server side scripting (ASP or ASP.net)
- the scripting for validation and display must be hand coded

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPa...3/Default.aspx
_____________________________________________


"Andy" <(E-Mail Removed)> wrote in message news2D36C57-9643-4050-8382-(E-Mail Removed)...
|I need to design a database that will allow for some assistance with audits.
| I am considering the following, but would appreciate any help and guidance
| from you all!
|
| My first stage is to design a form that will allow the user to input data as
| is recorded in some notes as well as the same data fields that should have
| been entered. Once entered, this data then needs to be run through some
| software (via some SQL script with .exe prompts to ensure it's as automated
| as possible). The data will then hopefully be outputted on a report,
| summarising the data that was held within the notes and the data that should
| have been recorded (including output fields from the software).
|
| I am therefore considering designing the database as follows.
|
| Create two tables (one for the notes data and one for the actual data).
| A form is created allowing user input that will dump this data into the two
| tables.
| These two tables are then exported and run through the software and two new
| tables created including the relevant software output fields.
| I then need to write a report to show all data fields (one set for the data
| held within the notes and one set for the acutal data and the corresponding
| outputs from the software).
|
| Looking for guidance/advice and how best to design. Appreciate it all sounds
| a bit vague, but happy to answer questions that people have!!!
|
| Many thanks