Hi Gents,
I'm a project engineer working on some piping & steel fabrication company in Malaysia. I haven't see any presentation page but just let me know if I miss it.
One of our biggest concern while fabricating parts is to follow up on quality and welding tracability, and I was looking for a database to manage it through a better user front end, capable of pulling reports, fab status, etc.
Ideally the end target is to expend it and have a multi user/responsible using this, with an interface for the project dpt, one for the QC dpt, etc. Current setup is using excel sheet for each task, with a lot of redundant information and replacing it by a database sounds the best option to me.
I designed the following database so far, an you may start to see where I am getting stuck.
I am trying to record the data for the welding joint, with different type of properties (welding #, welder name, date, drawing & project associated). The most important ones are the 2 parts which are being welded together.
So my first issue is to differentiate in a query, which info are from part 1, and wich info are from part 2? As you can see, I have 2 different attributes pulling info from the same table. Not sure if this is the approriate way to do it.
[suit to follow in next post]