Good Morning Mark,
I put [ append blank 'EachTableName' ] in the init event of the form and everything seems to be working. What I don't know is if what I did could cause problems that i'm not experienced enough to recognize. Do you forsee anything bad on my horizon?



>Is this failing when you run the APP? Are the tables included in your project? If so, exclude them. Tables included in a compiled app can not be modified at runtime.
>
>>It's not read only. I can append blank. this is what I did to find out. Went to project mgr, chose a table, chose browse, chose view | edit, went to the command window, typed append blank and pressed enter. What happened was that it appended a record, but when I entered a value in the record, it didn't add another record. all my tables are doing that.
>>
>>
>>>Check file attributes to see that they are not read-only. Can you Append blank to the tables? Do you have proper rights to the directory where the tables are located.
>>>
>>>
>>>>they all have the same name, all are integers, all have input masks of 9999.
>>>>the only differences are that 1 is primary, and 2 and 3 are regular; and that the default of the primary calls a getkey().
>>>>
>>>>
>>>>>The number of fields does not matter. What does matter is that you match field names and types. Compare the structures between the tables you are trying to append from and to.
>>>>>
>>>>>>actually now that I look at it, None of the tables will append. no errors either. the 1st table has quite a few more fields than the other two. what do you need to see as far as table structure?
>>>>>>
>>>>>>
>>>>>>>>I have 3 tables - table 1 has a primary key that i linked in my data environment to regular keys of the same name in the other tables. the problem is that the third table will not append new records and i don't understand why.
>>>>>>>>
>>>>>>>>HELLPPP!!!!
>>>>>>>>JD
>>>>>>>
>>>>>>>Do you get an error message? If so, what is it? If not, are you getting just blank records appended? Providing partial table structures for the 1st and 3rd tables would probably be helpful as well.