By markrei on

Im new to drupal is there anyone who can help me to solve my problem, I had a table view named PurchaseOrder with a fields named, Purchase Order Number, Date, Quantity etc... it will list all the details under PurchaseOrder Content type

All I wanted is when i click a specific Purchase Order Number e.g #3 all the P.O. # 3 will show in a table list...

*** Purchase Order Number type is title.

Is there a module who support this feature.. please help me..

Thanks in advance!!

⋅ Categories: Drupal 5.x

Comments

berenErchamion’s picture

berenErchamion commented

Are you trying to query and display records from a separate database or from the Drupal database?

The easiest way to accomplish your goal in drupal is to use custom types, views and panels. You could create a custom type called "PO", then views to retrieve your actual PO records and then use panels to display these in various ways on your Drupal site.

Hope that helps.

beren erchamion
http://tarnaeluin.wordpress.com/

markrei’s picture

markrei commented

Thanks for your reply.

I am querying and display records from the same database.. Yah i do have a custom type called "purchasorder" then i created a views with the same name" Purchase_Order" so it will list all the details under that purchaseorder content types but when I select a specific data e.g. p.o# 3 it will redirect to its node. All i wanted to see is when I select p.o.#3 it will list all the data with a named p.o#3.

Again thank you very much and I'll try to use panel module..

markrei’s picture

markrei commented

This panel module is great one. I can use it on my future project but I think it is not want i needed to or it is just I don't know how to configure it exactly..

Here is want I wanted to see on for e.g. I had a views named PO and it has a purchase order no,1,2,3 etc.

PO views from Content type PO
---------------------------------------------------------
purchase order # Qty Supplier Total Amount
--------------------------------------------------------

1 25 xxxxxx 29,000
2 10 xxxxxx 13,000
3

Each purchase Order had a multiple value when I click a p.o.# 2 for e.g. it will look like this; it will list all the purchase order under no.2

PO views
---------------------------------------------------------
purchase order # Qty Date Sub Total
--------------------------------------------------------

2 5 3-18-2008 6,500
2 5 3-29-2008 6,500

I hope that this is clear and thank you so much for your response..