Carl,
You have fields from "inventry" also marked as Update = .T....this does not seem kosher either if the key is for "wo".
>Erik!!!
>
>Woo!!! that seamed to do it!!! wooo!!! im jumping up and down!!! wooo!! Time to go to Champs and toast this great occasion!!! wooo!!!
>
>this works:
>DBSetProp('LV_WOMAIN', 'View', 'Tables', 'ream!wo')
>
>this does not:
>DBSetProp('LV_WOMAIN', 'View', 'Tables', 'wo')
>
>
>Wooo!!!
>
>I have been hacking on this for the last 2 or 3 weeks!!! it has sucked up at least 10-20 hours!!!
>
>Wooo!!!
>
>Thank you.
>
>woo!
>
>>>Here it the code I use to gen the dbc, and the view. at the end it tries to add a record to WO.DBF via the view. tableupdate() reutns .f., and message() reutrns "No update tables are specified. Use the Tables property of the cursor."
>>>
>>
>>Does it not make a difference if you prefix wo with the database name?
>>
>>"mydatabase!wo"
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05