Hi folks!
I need to design a DB which allows an administrator to easily see what kind of hardware and software is installed on all of the computers in his office. I therefor created four files: (1)Station, (n)Computer, (n)Hardware, (n)Software; where (n) are the files containing the details for Station. I have three 1-n relations set, which seem to be correct. The only problem is that I get all the hardware which is used on the Station, but only one softwaredetail. The softwaredetail shows me a different program for the same station if I sort the file. In the Layout the softwaredetailtable is the same as the hardware one. Both tables are put in the Head part in the layout.
All files contain the correct data. The data is imported from a 4D DB so all names for the relationship should be correct. (And I checked it manually)
Sorry about the bad explanation of my problem, but I am working with the german version of FM4, so I am not familar with the english explanations.