I have a main table (Lets call it "MainTable") that is linked to a
server that I do not have write access to. I want to supplement this
data with my own table (Let's call it "SubTable"), joining these two
tables by a common unique ID. All the data is to be included on a
single form. The main form contains the data from the linked table,
the subform will be the data I need to enter in the form based on what
is displayed in the main form.

Data from the main form is constantly updated and I have view to
access this data. I want to enter supplemental data using the subform
while displaying the data from the MainTable in the main form.

I have created the two forms and embedded and synchonized the subform
into the main form but the way I set it up, only those records that
have matching unique ID's show up in the form. New data entered in the
MainTable does not show up, only the data for which I have already
added supplimental data shows up. What I am trying to do is have the
form show two things:

1) If both tables have the matching unique IDs, show the data from
both tables.
2) If the main form has a record that is not matched to the unique ID
of the subform, update the unique ID in the SubTable with the
MainTable's unique ID so I can enter the supplemental data in the
subform interface.

This seems to be what is happening in the Northwind database. I added
a new record in the Orders table, in the table view. I was able to see
the new record in the Orders form and enter new data in the Orders
Subform. The data I entered using the Orders Subform somehow got
updated into the Order Details table while I was using the Orders
form. I cannot figure out how this was done.

Ideas anyone?