Everyone, I am totally out of my league here so any help you can offer is greatly appreciated. Firstly, my database is modeled for a manufacturing company production line. We want to report on employee and product performance on a given day. The database was not created by me but I have been challenged with normalizing it and thereby increasing reporting functionality and ease of use. Here is my challenge: The database has many tables but I have identified the following as my main tables: Line, Header, Printer, Customers, Workorders, Shift, and Employees. I need help establishing relationships between these tables. What I do understand is that the header and printer are both parts of the line and therefore should be related to one another so that we can generate reporting on the full line. Currently we are not able to generate a query that pulls all records for a specific line on a given day with both the header and printer details. I believe that once I get the relationships established then I can build the reports that I need. I have attached a watered down copy of my database. Thanks in advance for your assistance.
Database Relationships
- Thread starter lmg0115
- Start date
ajetrumpet
Banned
- Local time
- Yesterday, 21:14
- Joined
- Jun 22, 2007
- Messages
- 5,638
would love to help here...but there is simply too much information for me to sift through. Thought maybe you could be more specific as to what you need exactly...and maybe point us in the right direction?
georgedwilkinson
AWF VIP
- Local time
- Yesterday, 21:14
- Joined
- Mar 4, 2008
- Messages
- 3,856
My manufacturing model has over 100 tables. Not the kind of thing you'll likely get the solution for from a forum.
Just took a quick glance .... I will agree and say you probably are not going to find much help here due to the complexity.
Now, this doesn't mean it doesn't work - just means that I wouldn't touch it because of the scale of complexity. Also, obtaining a free fix from here, you might not have any idea what the repercusions could be to the rest of your database or when it would show up (due to the complexity - opinion without investigation). If this is critical to your company, might want to be wary of any free advice anyhow if you're not confident in what it will do or who it is coming from.
Not to put words into George's post, but in my opinion ... the sheer scope of what you want to do verses what needs to be done (fixed or bandaged), if time is of the essence - you might want to seek professional (paid) assistance.
If youre not in a hurry ... by any stretch of the imagination, here are some very good tutorials to get you started:
http://www.sienaheights.edu/personal/csstrain/Access2007.htm
http://www.functionx.com/vbaccess/
-dK
Now, this doesn't mean it doesn't work - just means that I wouldn't touch it because of the scale of complexity. Also, obtaining a free fix from here, you might not have any idea what the repercusions could be to the rest of your database or when it would show up (due to the complexity - opinion without investigation). If this is critical to your company, might want to be wary of any free advice anyhow if you're not confident in what it will do or who it is coming from.
Not to put words into George's post, but in my opinion ... the sheer scope of what you want to do verses what needs to be done (fixed or bandaged), if time is of the essence - you might want to seek professional (paid) assistance.
If youre not in a hurry ... by any stretch of the imagination, here are some very good tutorials to get you started:
http://www.sienaheights.edu/personal/csstrain/Access2007.htm
http://www.functionx.com/vbaccess/
-dK
Last edited:
ajetrumpet
Banned
- Local time
- Yesterday, 21:14
- Joined
- Jun 22, 2007
- Messages
- 5,638
I didn't think we were working as consultants.
Depends on what your definition of paid is ... if advice is the new definition of work then free is the new paid.
I would think if something like that was dumped into my lap and I was a bit hesitant or new to the arena, I would post something similar and then click-print --- see why I can't do it boss?
-dK
I would think if something like that was dumped into my lap and I was a bit hesitant or new to the arena, I would post something similar and then click-print --- see why I can't do it boss?
-dK
hehehe ... no problem! I've been in that seat before and instead of getting caught in a quagmire, I did (and will continue to do) the same thing you are doing.
It is kind of hard to say 'Not in my job description' but alot easier to say 'It's beyond my scope' and let the boss kick for training and/or professional help especially when they understand what is on the line.
-dK
It is kind of hard to say 'Not in my job description' but alot easier to say 'It's beyond my scope' and let the boss kick for training and/or professional help especially when they understand what is on the line.
-dK
ajetrumpet
Banned
- Local time
- Yesterday, 21:14
- Joined
- Jun 22, 2007
- Messages
- 5,638
Just trying to save your butt. Every boss I've ever worked for has known that the internet is full of a bunch of crap, and it doesn't do business. People do. Maybe I've been here for too long, but I can say with a great degree of certainly that we as advice givers on this forum know what we're talking about. That might not be the case with every forum you're on, but I think it's pretty good here.
