 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / March 2006How to map tables
Hi, i am not able to design tables in an efficient way. Can any one help me regarding table creation...Frist i wll explain the data to be stored. An automobile company manufactures gaskets. for each gasket they wil assign a part number. For each part thre could be multiple locations and each location wil have the control limits. After manufacturing they will measure the each part locations. i nedd to save the following information. location ,measured value, operator,--- name of the person who measured the value. shift Id-- company runs in 3 shifts. so i need to indicate the shift ID (1,2, 3) for each location check-- Either first Pc or lastPC status--- is it ok or not.... comments- not ok then he has to enter comments..... ReadingDate all locations are measured by the same person,same shift ,check,date. first i created a table named as MeasuredData contains the following fields PartNumber,location ,measured value, operator,shift Id,check,status,comments,ReadingDate but the above table will contains the repeated data... So i decided to maintain the data in 2 tables. MeasuredData --- PartNumber,location ,measured value, ReadingDate LocationMiscData--operator,shift Id,check,status,comments,ReadingDate (common information) But now i had some other problem....i.e. mapping... i have Date ,location filters when user wants to view the data... i am not getting the view as proper... if MeasuredData have 6 records then i am getting 18 records for that date... so can u help me how can i oraganize my data...... Thanks in advance... How many gaskets would be checked in a single day? Two per shift – per location? Location 1 Shift 1 first Pc lastPC Shift 2 first Pc lastPC Shift 3 first Pc lastPC This is six items checked at a location in a day. Is this correct? > Hi, > i am not able to design tables in an efficient way. Can any one help me [quoted text clipped - 31 lines] > > Thanks in advance... Per day they have to manufacture limited gaskets like 10k per day or it varies based on the production. They wil measure the first piece of the production and last piece of the production. So it can be shift 1 or 2 or 3. All locations are measured at the same time and locations for each part should be different. For example. Part:0102-07645-BR1 Location1 ,location2....LocationN Shift 1 First PC Shift 1 LastPC. Part:0102-07645-BR2 Location1 ,location2....LocationN Shift 1 First PC Shift 2 or 3 LastPC. Measurements can be taken only for the first piece and the last piece... >How many gaskets would be checked in a single day? Two per shift – per >location? [quoted text clipped - 15 lines] >> >> Thanks in advance... Here is how I see your table structure -- Table: LocationMiscData Name Type Size LocationDataID Long Integer 4 Part_No Text 50 Location Text 50 ReadingDate Date/Time 8 Table: MeasuredData Name Type Size LocationDataID Long Integer 4 Operator Text 50 Shift Long Integer 4 PC Text 50 Measured value Single 4 Pass Yes/No 1 Comments Text 255 Set the relationship between the tables. Use a form with subform for data entry. The Master/Child link between them will be the LocationDataID. The subform in datasheet view. > Per day they have to manufacture limited gaskets like 10k per day or it > varies based on the production. They wil measure the first piece of the [quoted text clipped - 32 lines] > >> > >> Thanks in advance... hi, I think this table structure still maitaining the reduntant information. For example Part_ID is 0102-07645-BR1 and locations are J a Hght,J b Hght,J c Hght,J a wdth,J b wdth,J c wdth and so on... Measurement on 3/8/2006 is as follows Inspector ReadingDate Shift PC J a Hght J b Hght J c Hght J a wdth J b wdth J c wdth ...... Gemini 3/8/2006 1 FP 0.034 0.045 0.056 0.023 0.067 0.048 Gemini 3/8/2006 2 LP 0.037 0.050 0.045 0.013 0.072 0.068 This could be saved in the tables as follows..... LocationMiscData 0000001 0102-07645-BR1 J a Hght 3/8/2006 0000002 0102-07645-BR1 J b Hght 3/8/2006 0000003 0102-07645-BR1 J c Hght 3/8/2006 and so on.... MeasuredData 0000001 Gemini 1 FP 0.034 yes ok 0000002 Gemini 1 FP 0.045 yes ok 0000003 Gemini 1 FP 0.056 yes ok... For each location i have to store like this...Number locations can be 50... For only FirstPC u have to maintain 50 records with the same information...There is no limit on the number of locations.. he can have as many as he want..... is it good one? >Here is how I see your table structure -- >Table: LocationMiscData [quoted text clipped - 23 lines] >> >> >> >> Thanks in advance... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.