First of all I should say I don't have a clue what I'm doing.
I'm trying to build a database which is for Software Inventory. What I have is a table that contains software. Something like:
1 Visual Studio .Net
3 Microsoft Office
Also there is a table which defines relationships between Software:
Id Parent Child
1 3 2
2 1 5
3 3 4
4 1 6
So this says that Word and Excel are dependent, or children, of Office and that VB
.Net and C# are dependent on Visual Studio.
I have a form which is designed to allow users to manage these relationships. It consists of two list boxes which list all the software in two columns, one for the parent and one for the child. The list boxes are displayed in alphabetical order. As you move from record to record the relationships are displayed within the list boxes.
Microsoft Office Excel
Microsoft Office Word
Visual Studio .Net C#
Visual Studio .Net VB
You can then delete a relationship, add a new relationship or change a relationship.
The relationship records come out in the order of the Relationship Parent Id not the order of the Software Parent Name which is what I want to happen. Any ideas how to get this to happen?
The form uses as its Source the Relationship table, I did change this to a SQL quer which seemed to work but then prevented me from updating the Relationship table. The Parent and Child list boxes then list the software name using a piece of SQL as follows:
SELECT tblSoftware.SoftwareID, tblSoftware.Software+IIf(IsNull(tblSoftware.Versio n)," "," - "+tblSoftware.Version) AS Expr1 FROM tblSoftware ORDER BY tblSoftware.Software+" "+IIf(IsNull(tblSoftware.Version)," ","- "+tblSoftware.Version);