Melissa:
I am assuming that both tables are in databases (DBCs). If so, then use the COPY TO .. DATABASE variant of the COPY TO command. For example, you could USE applicant and then:
COPY TO coapplicant DATABASE mydatabase (substitute DBC name as appropriate)
>I need two tables with the same data elements. One is to store Loan applicant information and the other is to store Co-applicant information. (Two seperate tables vs. a code field to indicate app or co-app was decided for ease of use when the customer uses a report writer.) When I exported the existing applicant table to a new co-applicant table, the "Display" (input mask, caption, ..) information in the structure did not get copied/exported to the new file. I have since tried Copy structure, Create from, etc. and still can not get the "Display" data to transfer with the structure. Any Ideas?
------------------------------------------------
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