Where do I type the code to requery my table?

[Lucy2003]

I'm using cobol wow to write an indexed file then I use relativity to make my file seem like a database file then I exported my data from relativity into a ms access database but now i have a problem. How do i update my table from my relativity database file using requery in ms access? Where do i put the code or is there another way to do it?

 

[beetee]

Are you 'linking' to the Relativity file, or are you Importing it?

if importing, you will have to re-import to keep in sync.

If linking, you will have to requery any forms or queries using the data.

 

[Lucy2003]

I'm importing the data from the index file to relativity file to access. How do you re-import and where do you put the code in access, does it go in a module, macro or query?

What I am trying to do is export data from cobol index file so the user can use ms access to edit/modify. These changes need to be saved back to the index file and then refreshed in access so data stream is consistent. Can get it to save back to index file, but this is where I get lost. There is a key that the user select to determine what lines of data to put in the set of data they want to view. We are not view entire file, only sections of file based on key. Relativity over writes the relativity file when they change keys, but when importing into ms access it creates a new table. Is it possible to have the data go into the original table and overwrite that data instead of creating a new table/form?

Not sure how clear this is. But any help will be apprectiated. Thanks