jon.wright
New member
- Local time
- Today, 14:32
- Joined
- Nov 23, 2010
- Messages
- 5
Hello all,
I am having a few difficulties with a query. my mind is completely blank on this at the minute.
The objective:
I have a table within datbase 1 called generic valve table which has various queries linked to it, to populate another table, Components-valve table.
Project specific, i need to replace/overright the generic valve table data with data from a table called ANSI Valve Table or PN Valve Table from a remote database.
i have a combo box on a form which the user can select what class of valve to use i.e. ANSI Valve Table OR PN Valve Table so this part is done i just need a query that i can link to this.
i dont want the Generic valve table to be removed as this will severe my relationships and other queries, i just need a query that replaces all the data from the remote database.
if anyone could please help it would be appreciated.
jon.
I am having a few difficulties with a query. my mind is completely blank on this at the minute.
The objective:
I have a table within datbase 1 called generic valve table which has various queries linked to it, to populate another table, Components-valve table.
Project specific, i need to replace/overright the generic valve table data with data from a table called ANSI Valve Table or PN Valve Table from a remote database.
i have a combo box on a form which the user can select what class of valve to use i.e. ANSI Valve Table OR PN Valve Table so this part is done i just need a query that i can link to this.
i dont want the Generic valve table to be removed as this will severe my relationships and other queries, i just need a query that replaces all the data from the remote database.
if anyone could please help it would be appreciated.
jon.
