Table form problems

[Silver76]

In order to get this right i will give you an example of my first three
tables and related forms.

Table One Management Systems which has 7 fields in it as follows.

1. QA
2. HACCP
3. Disaster Recovery
4. Operations
5. Social
6. Environmental
7. OH&S

Table Two - Genetics which has three fields in it.

1.Environment
2.Yield Optimisation
3.Shelf Life

Table Three - Propogation which has four fields in it

1. Seed
2. Fertilizer
3. Chemicals
4. Network Alignment

Each Field has their own form (All forms are the same where you give each a
marking out of ten (Click box) each value is worth between 10 and 100
percent. So in this example i have 14 forms.

I have a switchboard which allows me to choose which table then choose which
field i would like to give a rating for.

I have got to the point where i can click on the switchboard choose a form
and enter data and it populates that fields table giving it an individual ID
number. As all forms have an ID number.

However if i wish to enter management systems/QA form and enter a rating of
4. Then go to my switchboard and click on Propogation/ Seed ; i then rate
that category which populates that table's field.

My problem is i wanted that rating to be linked with the same id as
management systems/operations/4.

Or do three different versions on the same day, being able to access the
corresponding ID Numberor choose create new id which then allocates that
number for all other tables/fields.

I would like to this within the forms and tables

Sorry to be a pain in the backside as i am fairly new to this and trying my
utmost to get my head around it.

Cheers

Russ

 

[Damon Heron]

Wow is that confusing! 14 forms - 1 for each field, is not the way Access
is supposed to be used.

I have no idea what the data is that you are trying to capture, but my guess
is your tables are all wrong.
Try starting fresh and in a simple paragraph, state what you want the
database to do for you. For example:
"I want to record ratings given to all my operations at my widget supply
business by various employees." So then decide what the ratings are, what
the operations are, and who the employees are. Then create tables for
Ratings, table of Operations, and table of Employees. (This is just an
example, it probably has no relevance to your operations) Since Access is
used for a relational db, you need to have Primary keys and foreign keys
relating the various tables to each other.
The Ratings table, for instance, would have a primary key field, a rating
field, an Operations foreign key, and an Employee foreign key.

Damon