ACC2000: UniqueTable and ResyncCommand Properties Are Not Saved (263738)

MORE INFORMATION

Steps to Reproduce the Behavior

1. Open the sample project NorthwindCS.adp.
2. In the Database window, click Stored Procedures under Objects, and then click New. Type the following stored procedure:

   Create Procedure CustOrders
   As
   SELECT Customers.CompanyName, 
          Customers.ContactName,
          Customers.Address,
          Orders.*
   FROM Customers INNER JOIN
          Orders ON Customers.CustomerID = Orders.CustomerID
   					

3. Close and save the stored procedure as CustOrders.
4. In the Database window, click Forms under Objects, and then click New.
5. In the New Form dialog box, click Design View, and then click OK.
6. If the property sheet is not displayed, click Properties on the View menu.
7. In the property sheet for the form, click the Data tab, and then set the RecordSource property to the CustOrders stored procedure.
8. If the field list is not displayed, click Field List on the View menu.
9. Drag all fields from the field list to the form.
10. In the property sheet for the form, click the Data tab, and then set the UniqueTable property to Orders.
11. Type the following SQL statement in the ResyncCommand property:

    SELECT Customers.CompanyName, Customers.ContactName, Customers.Address, Orders.* FROM Customers INNER JOIN Orders
    ON Customers.CustomerID = Orders.CustomerID WHERE Orders.OrderID = ?
    					

12. View the form in Form view.
13. Change the CustomerID field of the first record to a different, valid CustomerID (for example, WOLZA). Move to the next record in the form, and then move back to the record that you just modified. Verify that the resulting information appears correctly (that is, CompanyName, ContactName, and Address fields).
14. Close the form. When you are prompted to save the form, click Yes, and then click OK to save the form with the default name.
15. Open the form in Design view, and then view the property sheet for the form. Note that the UniqueTable and ResyncCommand properties are blank.