I have a split form, I have included a screencap below:
As you can possibly see, this is showing data on commissions (I'm a professional photographer) and this is a record created to test the database. Commissions is one table and most of the data visible in the screencap is from that table. There is a another table called Appointments, and the Commissions-Appointments relationship is one-many. Towards the bottom of the form you can see a subform listing the appointments which are associated with that commission.
To the left of the form you can see the datasheet for this form as it is a split form. I have hidden most of the rows as I simple want the datasheet there to help me navigate through commissions.
My problem though is that because I have the appointments subform, there is also an appointments sub-datasheet (you can see the little +'s next to the records in the datasheet). I don't want this, also because there are 3 appointments for the 'TEST' commission, it appears 3 times in the datasheet. I have no idea about this either.
As you can possibly see, this is showing data on commissions (I'm a professional photographer) and this is a record created to test the database. Commissions is one table and most of the data visible in the screencap is from that table. There is a another table called Appointments, and the Commissions-Appointments relationship is one-many. Towards the bottom of the form you can see a subform listing the appointments which are associated with that commission.
To the left of the form you can see the datasheet for this form as it is a split form. I have hidden most of the rows as I simple want the datasheet there to help me navigate through commissions.
My problem though is that because I have the appointments subform, there is also an appointments sub-datasheet (you can see the little +'s next to the records in the datasheet). I don't want this, also because there are 3 appointments for the 'TEST' commission, it appears 3 times in the datasheet. I have no idea about this either.