Display data from multiple linked lists

[java61]

Let's say I've 3 lists:
Order (number, date, customer link, ....)
Product (code, label, price)
Order lines (order link, product link, quantity)
I would like to see under the Product Webpart the list of linked order lines.
It's not a problem with connected WebParts.
But now, I would like in this list to see informations from order lines AND from order (ie order date).
How could I achieve that ?

THANKS,
Gilbert

 

[globalstrata]

I would think that you would use access for this to query the lists. Write an Access form that uses link tables.


Gladys Rodriguez
GlobalStrata Solutions
Computer Repair, Website Design and Computer Consultant
Small Business Resources

 

[java61]

I would like to put all that in SHAREPOINT.
Possible ?

 

[globalstrata]

Microsoft Office SharePoint is a utility that interacts with the Office Products. For more information about the type of interaction that you have with the Office products see:

http://www.microsoft.com/technet/pr...er2003/technologies/sharepoint/spoffint.mspx.

Although I mentioned about Access, basically the data will reside in SharePoint. You just would use Access as the front end. This is the same as having a web form. If you prefer not to use Access, you can use Infopath or write your own web form and display it using a page viewer web part. This is just deciding what is easier for you and the users that will be using the form. Once thing to consider is that the next version of InfoPath will allow form conversion to web page. In other words, any forms that you create at this time, in InfoPath, will be easily converted to html in the new version once it is released.


Gladys Rodriguez
GlobalStrata Solutions
Computer Repair, Website Design and Computer Consultant
Small Business Resources

 

[java61]

Ok, THANKS !
Now I understand your answer.
I thought that sharepoint was able to do that directly.
I think the same answer is for updating data in tables which are not inside sharepoint.
For exemple, I've a table "Person" in an SqlServer2000 DB. I can easily display it but I'm not able to modify it directly with sharepoint base webparts.
I think now I've to develop a specific Webpart, with Access web pages or C# or infopath.
Infopath is not the solution for me as it's 199$ per PC (we and our customer don't have the PRO version of office).

 

[globalstrata]

SharePoint does not do this directly. You have to use Access, InfoPath or a custom web part (one that you build).
As I mention, next version of Infopath will have the capability to save the form to web based so then you would only need InfoPath to create the form but not to use it.


Gladys Rodriguez
GlobalStrata Solutions
Computer Repair, Website Design and Computer Consultant
Small Business Resources

 

[java61]

THANKS AGAIN
So, probably next InfoPath version will be a large part of my solution.

Any idea of release date ?

Otherwise I'll develop my own C# Webpart si I'm quiet sure I've no limitation ... and no distribution fee !

 

[globalstrata]

Probably you do not want to wait for it. It will be released sometimes next year.


Gladys Rodriguez
GlobalStrata Solutions
Computer Repair, Website Design and Computer Consultant
Small Business Resources