I have set up an accdb that links to tables from Epicor 905. My plan is to query data from Epicor and build a local table to associate with that data. The query I set up that gathers data from Epicor has been set up as Recordset Type = Snapshot so the form user will not be able to change the Epicor Table data.
What I would like to do is have a table that I can store records in that associate to an order number from the Epicor query that I have build specifically filtering on the Order Number as the linking field (master?). I will need to have multiple records in the accdb table associated with the Order Number from Epicor.
Also there is some data that is viewed from the Epicor query that I would like to save to this local table, preferably by the user pushing a button that is not currently on the form. I have attached my recent attempt.
Any help would be greatly appreciated.
Any help would be greatly appreciated.
What I would like to do is have a table that I can store records in that associate to an order number from the Epicor query that I have build specifically filtering on the Order Number as the linking field (master?). I will need to have multiple records in the accdb table associated with the Order Number from Epicor.
Also there is some data that is viewed from the Epicor query that I would like to save to this local table, preferably by the user pushing a button that is not currently on the form. I have attached my recent attempt.
Any help would be greatly appreciated.
Any help would be greatly appreciated.
