Data from specific tabs to specific tables

[thinair421]

Data from one form to multiple tables

Hi,

I have a question concerning the database that I am working on for a company I am interning with. I started with absolutely no access knowledge, but I have been teaching myself via forums and online help (and the obvious trial and error) over the past couple weeks, so please bear with me. My questions are:

1) I will have roughly 18 different forms, each with roughly 10-15 tabs in each. Under each tab I have several different text/combo boxes that the user can enter data into (or select in the case of the combo boxes). There is anywhere from 5 to 60 of these data fields under each tab that the user can enter data into.

2) What I would like to know if it is possible to save data from say 10 of these data entry fields from one tab to one table, and 15 data fields under the same tab on the form to a seperate table, ect. (numbers in part 2 are for example only). I need to do this for multiple tabs...

3) I am using the date as my primary key on every table, and would like all data sorted by date.

4) For overall design, would it be more efficient to create all of my tables with all of my field values that I will have, and then the form...or should I create all of the forms first, and then create the tables based on the form's fields. (the 2nd option I'm assuming will be much easier, as I do not know for sure all of the fields that will be on the forms yet, and I dont want to forget one on accident).

If anything is not clear, please let me know and I can try and elaborate more. Thank you all in advance.

 

[thinair421]

Data from one form to multiple tables

OK so let me rephrase this in terms of a picture and what I am actually trying to do (or atleast think I should do)....

So I am designing this program/database for a plating department (parts get dipped in tanks of chemicals to be plated with various metal finishes), so that they can track the cleanliness/usage of the tanks. There are roughly 20 different tanks, all of which need to be maintained. So the company has a list of tasks for each tank, broken down by frequency (daily, weekly, biweekly, monthly, and quarterly). Here is how I am trying to make the database:

1) There will be a form for each frequency, for example: a daily form, a weekly form, ect... and each form will have all 20 tanks on it as tabs. For instance, when the daily form is opened, the user will see several tabs, each with a tank # on it. When they click a tab they will see the list of tasks for that particular tank displayed below (ie. pH reading, temperature). They then perform the indicated test(s) for each tank and enter the info into this form.

2)Once the data is entered, it will store it into tables...my company would like a table per tank & frequency (ie. tank 001 - daily, or tank 005 - monthly).

3) My question is, what are my options as far designing this. Should I set it up so that when the user clicks on one of the tank tabs, that a subform appears instead of trying to link all of the text/combo boxes under each tab to their respective tables? That makes the most sense to me as I believe this would give them the exact lising of what they want to know. (dont know if this is possible tho).

4) My final goal is to have frequency tank tables (ie. tank 001 - daily) with all of the dates of the data entry as the first column (primary key) and each test/procedure performed on the tank listed on that same row, in its own column.

Ok I sense I might be getting confusing. Please help as I cannot move forward on this project without figuring this out. (and I am tired of restarting). Any help would be great. Thanks

Oh, and I have attached a horrible windows paint diagram of a sample "flow chart", if you will, of what Im trying to accomplish (daily task only for example) and of how i want the data to be stored. Many more tanks will be taken into account than just 3 or 4, and tasks will occur weekly, monthly, ect. so this will be slightly complex.