Question Hi, my name is Hugh and I have a problem...

[HughJ]

Hello, this is my first thread here, i am from argentina and my english is not so good, so i will try to do my best.

I am working in a DB under access 2007, Wich will handle information about Reaserch Safety Plans of an University.

I have managed to design my DB normalizating all my tables up to 3NF, leaving my relationships in the way of one to many.

All my tables are empty except for those that have a small and fixed quantity of records (ie: tblDepartments or tblRating)

I have reach a point where i need to add records simultaneously into multiple tables in order to add a record that represents a single "Safety Plan"

Well, i know i must use forms based on querys for this, but my access knowledge wont let me go further.
I really need help, and i realize this is a hugh question.

I know what my form should look (what information will accept and put into the tables).
Basically it will work as a data entry form to populate all my tables with information i already have in a horrible excell spreadsheet.

If someone is willing to lend my a hand i could be more specific, like attaching my relationship layout (only 9 tables)

Thanks in advance

 

[Mr. B]

Hi, Hugh and welcome to the forums.

If you will be more specific with your questions you will get more assistance.

Start with one thing that you want to do and ask about that. Then move on to the next thing. Remember, one thing at a time and try to explain the entire situation.

What version of Access are you using?

 

[HughJ]

Hi Mr. B

I am working under access 2007

If u look at the 2nd screenshot, the highlighted fields are those which i need to load into my DB

I want to make a form that let me do that.

I think that is my starting point, and i need to understand how is it done

I made a query selecting those fields, and then i made a form based on that query...

did not work at all

 

[Mr. B]

I'll make a stab at trying to help, but you still don't give us much to work with.

From the look of your table structure, your form would need to be built using the "tblAudit" table as the record source for the form.

You would then need a combo box for the Calification field with the records from the "tblQualification" table displayed in it. You would have another combo box for the "AuditorID" field and display the records from the "tblAuditor" table, as well as a combo box for the "SaftyPlanID" field displaying the records from the "tblSafteyPlan" table.

These combo boxes would need to have at least two colums, the ID field and another descriptive field that the use can use to select the appropriate values from the combo box. The Id field for each table will be the "Bound" field. The Column Widths property will need to be set to "0" (zero) as the width of the first column and then an another number as the width for the second columm.

You will need a form where the Saftey Plans can be managed. This form would have the "tblSafetyPlan" table as its row source and a couple of combo boxes, one for the "tblInvestigatorLabor.." records and one for the "tblDepartamento" records.

There will be other forms that you will need in order to properly manage this data, but hopefully this will help get you started.

 

[HughJ]

Hmmmm

From what you understand by looking the structure... I realize I did not do a good design... because in mi mind everything is based on the table SafetyPlan

I have been adviced to change this structure and re-think the design

So please, avoid for the moment correct this db
I am quite sure I will have some specific questions later on

I do appreciate your effort