Ms Access front end MS SQL backend

[Phokojoe]

I have an access database which uses 2 forms to enter data in 1 table. The other form is a subform and is continuos whereas the other (Primary) is not continuos.

It works fine in an access database but when I migrate the database to MS sql server database, the access front end especially the continuos subform does not work fine. I have the repeating records for a particular Id in the primary form that is why I use the continuous subform.

Please help me. Help urgently needed.

[sashi]

Hi there,

"repeating records" you say?? well.. check the primary key.. good luck my fren.. :)

[Phokojoe]

All I am saying is this: I have 2 forms. the other form is a subform. The information that these 2 forms enters go to a single table.
e.g. Form1 will enter the Item ID and the sub form will enter all the people who have ordered that item.
Hence the subform will have many rows coressponding to one ID in the main form. That is, we can loop in the subform. It works fine in the access tables, but when I migrate it to Ms SQL database, it does not. Hence I have the subform as a continuos form but when I migrate the back end to SQL server database, it looks like the continuos property does not work in the subform. The problem here is a subform being continuos not datasheet or single form.

I hope I have made my point clear.
Thanks