ODBC table read to blank Access table write

[dibblejon]

Hi



I have two ODBC linked tables from our system which must be read only. I need to create a new table that data can be written to via a form and sub form that pulls some data from these two read only unrelated tables.

Can anyone advise me whether this is possible? And how I could achieve?

Many thanks

[NTC]

well it depends on what you mean; you see these tables while in the Access database - can open them and can see all the data; but you are not able to change any of the data.....

so you are saying you want to write this data to a new local table? - one could import that data to a new table or one could write a WriteQuery of that linked table to create a new table.

forms/subforms at this stage have nothing to do with your task; once the new local tables exist then they can be the record source for forms....

[dibblejon]

Apologies for my poor explanation of what I am trying to achieve.

Basically I have two tables that are connected via ODBC and are to be used as look up tables only.

Table 1 : Customer (provides live customer account details)
Table 2 : Stock (provides live stock details)

These tables do not have a relationship.

I am looking to build a data input form that looks up a few fields from these tables and then writes additional data to a new local table eg.

From Table 1 the user will select an AccountID which when entered on the form will return the AccountID, AccountName, AccountPostcode

From Table 2 the user will select the StockID which will return StockID and StockDescription

Additional data will then be added by the user which will be stored in my new local table together with the data "looked up" from the other two tables. This table will need to keep multiple records for each AccountID.

The new table needs to be a blank table to start with and then build as data is entered into it.

I have tried adding Combo boxes which lookup the read only tables and then use the store data in this table option - but is not proving very easy to tie it all together.

I am sure that I am probably going about this the wrong way, further advice is greatly appreciated.

Many thanks