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 |
#35
|
|||
|
|||
Table/Forms Design Question
Hi Gena,
Lets start with weather. I only need this field per day. ex. It was sunny on monday so the weather would be Sunny. All Jobs are together in one daily report so I do not need weather for each Job. Let me show you the excel sheet for the dailt report. I know I can't think like in excel but maybe you get a better idea of what i am trying to create. ( http://img9.imageshack.us/img9/2928/summaryreport.png ) Here you can see how the Description is connected with (Area)-(Subcontractor withTrades(TblCrewTypes)) and (Equipment). Now Subcontractors are names of Firms. They do not have First and Last name, so I dont know how they would fit into TblCrew. In this excell Trades(which are CrewTypes) are together with Subcontractors, I want that seperate in access and it probably makes more sense. TblJobs is just to see how many Foreman-Workers & Laborers the MAIN GUY from each TblCrews had. Also Subcontractors have a number of Foreman and Workers assigned to it. Subcontractor is a Firm so no First/last name and we dont care what the names of Foremans or workers are just how many each subcontractor had. Thats why in the Summary we dont need to see the names of Crew, just the CrewType they belong to. BUT we need totals for the TblJobs(maybe its a bad name for it, it only counts the # of F+W+L). Maybe we should call TblJob something else like TblNumberOfFWL (FWL = Foreman-Workers-Laborers) This report is so simple its complicated lol. This excell is simple and not good. I Know Access can do this much better and probably will look and act totally different then the excel, which I want. I just cant stop looking and thinking like the excel sheet, I know that, but I cant stop lol. Am I making any sense with all this? Do you see the Relationship between TblSubcontractor, TblArea and TblEquipment.? ex. AREA(SouthControlBuildong) Subcontractor((Skanska)or(Carpenter)) Activity/Description(Cleaning out the aeration tank) Equipment(pulley) Thank You "Gina Whipp" wrote: Answers in-line... -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Damian" wrote in message ... Here are the new tables and relationship screenshot. ( http://img32.imageshack.us/img32/377/relationships2.png ) I left weather out since it has no connection to anything. I just want to use it later as a Headder on a form or report. Are you looking to Weather as in, "Rained Today" OR Weather the day of the Job? How many Jobs are going to be put in here? If you are going to show the Weather the day the Job is being done then you need to include weather in tblJobDetail (I explain why you want that later on.) Also the jDiscription is your tblJobs I took it out because the only description that will be entered is for Subcontractors. Also I linked Tbl Subcontractors to Tbl Job Detail Summary because it will be using 2 fields from Tbl Jobs (Foreman and Workers). Explain how you are using Description in the Subcontractors table. Also, why do you need a seperate table for Subcontractors? Why not add them to Crew and set the Crew Type as Subscontractors? You really don't want seperate tables for each Crew member type. That would be like having a seperate table for Administrative Assistants, Manager, CEO, etc... You want one table that you can specify Crew member type. I know that I should not be thinking about Forms and Reports but I want to see the Big Picture and Understand how to set up tables and Relationships. I learned that TblDetail is used as a pass-through table right? so thats why I dont think I need to link weather because its only going to be used once per daily report to show what the weather was like today. tblJobDetail is not a pass-through table, it is exactly what it says. There will be ONE Job but many Crew memeber attached to that Job. There will be ONE Job but several pieces of equipment will be attached to that Job. Making any sense? As for Forms and Reports... they are just Windows allowing you see Outside world (the data). Setting up tables has nothing to do with how the tables look, the same way the Window in your home can't control what you see outside, just that you can see outside. Make sense? Think One-to-Many... One natural Mom (Job) per child ----- and a Mom can have ten children (Job Detail) The data is not private. I can send you thw whole excel sheet if you like. The guys where using that for a while but it failed miserably since it cant be accessed by more that one user at a time. I think we might be okay so won't need the Excel spreadsheet right now. More tidbits... 1. Get rid of the spacing in your table and field names (if there are any), it will only make extra work for you later on. 2. Explain the whole Equipment scenario to me... I'm not sure I understand why Area is in it and how you use it except to assign Equipment to a Job. -- Gina Whipp SNIPPED |
Thread Tools | |
Display Modes | |
|
|