Copy a field from a table to another

[jleboeuf]

Hi !!!

I have two tables PRVDOS (come from another database Import)and QUESTION (copy of the first column(docket number) and many text field to enter data). Each day new docket are open and i have to update my import table.

what i try to do in a macro:

1- delete the relation between my tables
**** still don't find a way to do that ****

2- delete a table from the database
**** DeleteObject action in macro ****

3- import the table again from another software
**** TransferDatabase action in macro ****

4- copy the column docketnumber from PRVDOS in QUESTION
**** when i do manually i select the column docketnumber copy and do a paste append in QUESTION (same column name)

5- redo the relation between my two table.

thx for help Jean-Paul Leboeuf

jleboeuf@iquebec.com

 

[jimturner]

This may seem a little obvious, but do you need to import the table? Can you can link to it instead?