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?

Austin, Texas