Hi
Im new to this software and i wonder if it possible to make some report from a MS SQL databse with more than one table?
I try to explain.
I have a databse: DB01
In this database i have 4 tables: Article, Order, Property, Measure
In the Article table i have this Row: Articleid, Articleno, Articlepartname
In the Order table i have fkArticleid, Orderid, Orderno, Description, Customer
In the Property table i have fkOrderid, Propertyid, Name, Nom, utl, ltl
In the Measure i have fkPropertyid, measureid, measurevalue, timestamp
Now i want to connect this tables to get out some information.
I want connect this tables together like connect the order table to the article table (Otder.fkArticleid=Article.Articleid)
And then connect Property table (Property.fkOrderid=Order.Orderid) ......
Is it possible to make this type of report in SOFA?
Best regards
Patric