| Author |
Topic |
|
daipayan
Posting Yak Master
181 Posts |
 Posted - 2009-02-05 : 14:38:21
|
I had created a database named as supply_chain_mgmnt for a company, here I have to show pending orders of items ordered with respective their suppliers, after checking the goods received details. I need in normalisation mode.Am attaching the database screenshot for reference: Hope someone can give me some suggestion!Daipayan.. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-06 : 09:39:12
|
| i cant view the screenshot |
 |
|
|
daipayan
Posting Yak Master
181 Posts |
Posted - 2009-02-07 : 00:05:57
|
quote:
Originally posted by visakh16
i cant view the screenshot
This is the link of my screenshot:[url]http://users2.titanichost.com/daipayan/scm.gif[/url]DaipayanDaipayan |
|
|
|
mapidea
Posting Yak Master
124 Posts |
Posted - 2009-02-07 : 00:57:24
|
| Can you be clear with your question. You want a query for? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-07 : 07:45:46
|
| you dont have any relation b/w Order_Details and Good_Received_Details? |
|
|
|
daipayan
Posting Yak Master
181 Posts |
Posted - 2009-02-07 : 09:21:36
|
| @mapideasee I have Items Ordered related to Items Ordered Details and Goods Received Details related to Goods Received Items. Now I have create such a query so that user can see who are the pending suppliers to whom we have ordered, but cannot supplied the full ordered items, that you can in Goods Received Items.Hope you understand my problem!@visakh16I know, there is no relationship and this the challenging part, without doing this I want to create a view query.Please, can you help me?Daipayan |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-07 : 09:30:47
|
| how will you link suppliers to items they supply? |
|
|
|
daipayan
Posting Yak Master
181 Posts |
Posted - 2009-02-07 : 13:57:09
|
quote:
Originally posted by visakh16
how will you link suppliers to items they supply?
am linking directly with supplier details tableDaipayan |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-07 : 14:05:23
|
| but diagram doesnt show any relationship?? |
|
|
|
daipayan
Posting Yak Master
181 Posts |
Posted - 2009-02-07 : 15:31:35
|
quote:
Originally posted by visakh16
but diagram doesnt show any relationship??
Yes, I know that, but am creating the whole application in ASP as frontend and MS SQL 2000 as backend, so when I am going to add supplier details, am doing so through ASP codings.Daipayan |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-08 : 01:09:06
|
| i still cant understand how you will determine pending orders of items ordered with respective their suppliers if you dont have a way to relate to suppliers |
|
|
|
daipayan
Posting Yak Master
181 Posts |
Posted - 2009-02-08 : 03:42:53
|
| I know, my database design is not so good, still I managed to get suppliers in goods_received detailsCan you suggest me, how to re-design my database, please?Daipayan |
|
|
|
|
How to find Pending Orders