Arthur van Egmond 15.Aug.11 09:33 AM a Web browser Approach 9.8 All Platforms
I want to make a report out of two databases. I have joined both databases. The first database audio has a cdID numeric field and the second database has a OncdID numeric field. These fields are joined. I have tried all reports available in Approach but was unsuccesfull in showing all the data I want.
In te top half of the report I want the record from the database audio. p.e. cdID=01, cdTitle=some title, etc
In the bottom half of the report I want all the records from the database songs that has the same number in the OncdID field.
so if I have songTitle=some title, OncdID=1, track=1 and songTitle=another title, OncdID=1, track=2, etc I want all these records to been shown in the summery? repeating panel? anyway at the bottom of the form.
I have tried to put the fields from the audio database in the header but than I end up with audio.cdID, audio.cdTitle, as the data in the field when I am in browse, when I am in design I can see the information I have added in the test record. Also I only see one record from the database songs in the bottom once I go into browse mode but again can see all records in design mode.
In the option tab of the form I have enabled the outer join with audio at the first and songs at the second field. Also I have made the audio database the main one on the basics tab.