If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Table form problems
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 |
#2
|
|||
|
|||
Table form problems
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 "Silver76" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|