Query to Table Question

[ITGUY99]

I currently have an Access database that I attached to our Oracle system. I am trying to setup a table that shows our current open orders. I have a MAKE-TABLE query that creates a table from the Oracle links. Since every time I create the table it deletes the old table, I cannot create a relationship. I thought about an append table but it keeps adding records to the existing table. Is there any way I can set it up so that I only get one record for each order?
I am trying to set this up so that I can get a snapshot of the oracle data at night when no one is on the oracle system.

I hope I explained it enough.

Thanks in advanced.

 

[BlackKnight]

Hi,

Perhaps, you could run a delete query first and then run the append query? THis way the relationships would remain intact.

DELETE * FROM tblOpenOrder;
'Put the comma-delimited field names and field values in the respective parentheses.

INSERT INTO tblOpenOrder () VALUES ();

Have a good one!
BK