Help needed with stored procedures

[tbrowne]

I've been searching for an answer to this question for several days to no avail. I'm new to ADP's and looking for a more elegant solution that the one I am using. I am migrating an existing Access database to an ADP with a SQL Server 2008 back end. I have a main form, order info, that contains a subform, order details. The subform is used to enter products for the order. The user enters the product number to be ordered, then the subform displays the product name from the products table and allows the user to enter the quantity ordered. With the mdb I used a join query that returned the order detail info and the product name from the products table. I've learned that a view or stored procedure that contains a join is not updateable. Therefore I retrieve only order details from the order details table and then execute a stored procedure after the product number is entered to display the product name. This works, but it's slow and isn't going to get the job done.

I'd like to be able to return a single, updateable, recordset to the subform that contains order details info and the product name, thereby eliminating the extra call to the sp to get the product name. I havn't been able to work this out, but I know there must be a better way than what I'm using.

 

[PWise]

Look @ the UniqueTable Property

 

[tbrowne]

Thanks so much! That looks like the answer I was looking for; however, the drop down list on the form's data tab for 'Unique Table' is empty and it won't let be type a table name in. I found some other internet posts that reference this problem, but none showed the resolution. I'm using Access 2000, SP3, at work to try the solution. I have Access 2007 at home, but I can't try that until later.

 

[PWise]

The following is my workaround to this problem

Set the record sourceof the form to the table that you want to be the Unique Table .

Select thet table as the Unique Table

Change the record source to the stored procedures

 

[tbrowne]

OK! That worked and I thank you!