Linked Tables/ Obdc Db..lots Of ?'s

[Breathe]

I can't get a lot of answers about any of this..so maybe some one can help me.

Have ODBC tables that are linked to several different places within an Oracle DB.

I need to pull them all together into an access DB, using the linked tables and tables I have generated for data entry to track all our stuff in one place. (My goal is a switchboard)

I can't get some of the linked table fields to co habitate in the same Form as non-linked tables..

I want the linked tables to be updated frequently,but NOTT overwrite the 'regular' tables

 

[Breathe]

I don't think that I stated the question very well..

I understand what a form is, I understand what ODBC tables do. What I want to do is perform a query joining a linked ODBC table and a table that I have created. I will need the query to be in a form so that there can be data entry made to the fields that are part of the tables that are NOT linked. It will be a comparison of tracking data between what is updated through the ODBC data and the data entry by the users. I just can't get it to happen in th same place.

Did that clear it up?

 

[crook]

Sometimes updating queries is troublesome... I'm not even close to being an authority on this, but here is something to think about:

1. If the two tables are related one-to-many, and the one you want to update is the 'many', your query must be set to accept inconsistent updates in it's properties. Not sure this is the best way to go...

2. You might set your form up so that it's datasource is the table that you don't want to write to. Then put a subform on there with a datasource set to the table that you do want to write to.

Hope that helps,
- dave