Moving Source record to a TEMP file

B

BMc

I am trying to move a source record (ODBC) to a temp table. There in no
unique key to do so. Of course, I cannot add a check box or anything to this
table to move this record to a temp table. HELP!!!
 
J

John W. Vinson

I am trying to move a source record (ODBC) to a temp table. There in no
unique key to do so. Of course, I cannot add a check box or anything to this
table to move this record to a temp table. HELP!!!

Is there ANYTHING in the record that lets you identify it? If not, how on
Earth can you tell which record to move (manually or programmatically)?
 
B

BMc

I just started trying to do this database. It is so strange. All of the
records are expenses on a detail level coming from ORACLE on the backend.
They want our database to break all the cost down to the lowest level which
is the dollar amount and some of the orgids might change extc. There is NO
unique key or anything, just the dollar amount is unique. So far, the dollar
amounts are all different. I hope that this help.
 
J

John W. Vinson

I just started trying to do this database. It is so strange. All of the
records are expenses on a detail level coming from ORACLE on the backend.
They want our database to break all the cost down to the lowest level which
is the dollar amount and some of the orgids might change extc. There is NO
unique key or anything, just the dollar amount is unique. So far, the dollar
amounts are all different. I hope that this help.

As noted elsethread... more info needed about your table structure.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top