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.
Mark McCasland
Midlothian, TX USA