Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bachamp
Starting Member
1 Post |
 Posted - 2006-05-30 : 19:55:52
|
| This question is about Access, I know it is meant to be about SQL, so im sorry, but i need an answer. Later on I will have to convert it to SQL but at the moment im trying to get it to work using Access. I thought that some people on where will know access, or even be able to use the sql code in Access to help me. I’m a newbie to Access, I have done some simple things but I now have to do something that is out of my league.I work in an engineering company and I'm trying to make a database that the engineers can use to select a specification quickly, a specification or spec is like a table. Things like materials, ratings, pipe Schedule, etc are stored in it. The spec says how strong a pipe will be.When selecting a spec you have to look at the service (what the pipe is caring, eg high pressure steam, or low pressure water). Services also store things like Design Temperature and Design Pressure.You are giving the Service, and you have to select a spec that will be able to handle the Design pressures. To do this you compare the Design pressure to the Maximum allowable Pipe pressure (it is calculated at the join (flange) as this is the weakest point). One other pike of information is the Tables that have the Maximum allowable Pressure. To find the Maximum allowable Pressure, you need to know the Material, Rating and the Design Temperature. Each material has its own table.If you have a look at the file (i cannot attach it so I have attached it here http://www.access-programmers.co.uk/forums/showthread.php?p=494518#post494518)In the tables, SPec has Spec ID (Spec) which is Primary Key. Flange Material (FlangeMat) and Flange Rating (FlangeRating).The Flange Material should take you to another table, FlangeMat. This table is used to get you to the correct Maximum allowable Pressure table.There are 2 Maximum allowable Pressure Tables, TABLE_211 and TABLE 212. Here the rest of the information from the Spec is needed (Flange Rating (these are the field names with 150, 300, 1500, etc numbers)). And also the Design Temperature is needed of the service.Then it looks up the Maximum allowable Pressure from the Table and displays it. I was thinking a form.Also the design Pressure needs to be displayed so the engineer can compare the two.So for the form, there will need to be a drop down that has the Service, A drop down that has the Spec, and the two values, the Design Pressure and the Maximum allowable pressure.All I have done is shown on the file, I started to play around with the Relationships and tried to create a Form but I could not get it to work so. I deleted it and left it with just the tables. If possible can someone please help me, maybe even get my file to work and the post the working one, I will then be able to understand it.<edit> Moved to MS Access Forum </edit> |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-05-31 : 15:58:45
|
| Well, it looks like you have a good start on requirements gathering. Now, go hire an Access database developer and give him the specs... |
 |
|
|
|
|
|
|
|
Engineers and Databases, Not a good mix...