January 2nd, 2014, 05:18 PM
SQL Server 2008 with Microsoft Access 2010 FE
I have been experimenting with SQL Server 2008 and Access 2010 as a front end for the database, using the linked tables option to Access 2010.
Everything is going well till I tried to add a sub form to the main form as a one to many relationship. On the sub form, I seem to be getting one row repeating itself 5 to 6 times and no other information.
Never seen this before in Access. Can anyone point me in the right direction to correct this?