General information
Category:
Coding, syntax & commands
Thanks to a local VFP developer and friend, Dave Smith at Lockheed Martin in Lakeland, FL., for helping me on this.
It turns out I had my OrderItems view created wrong...I had specified the wrong field as my Key field. I choose the Order_ID field. While that was unique in the orders table, it is not unique in the OrderItems table....The field I needed was the Report_num, which is the Order_ID+RECNO()
Rick
----------------------------
>I have a form based on 12 views, 6 of which are updatable.
>1 - Order info
>4 - Address info (residence, employer, education, licensing)
>1 - Order Items (table - OrderItems) (view - vpOrderItems_Order_ID)
>
>The first five update fine. OrderItems gives me a mixture of correct and incorrect results. All fields are stored correctly, except the Sup_ID, Report_Num, and Report_ID. These store info from one record (from vpOrderItems_Order_ID) into each record (of the same order_id) in the OrderItems table. The information is correct, on the individual records in the view. And the rest of the fields go over correctly.
>
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only