Linking Split Tables

C

Chris

I have an spreadsheet I've imported to Access with a few columns of repeated
data. I've split these repeats into seperated tables using the analyzer. This
makes for easy searching in a form/query using a combo box as it eliminates
repeats in the combo box itself.

My problem lies in updating and adding new records. I'd like to be able to
add a new record via a form and have it update the underlying tables, which
will inturn update my combo boxes used for searching and at the same time.

I'm fairly new to Access so hopefully this makes enough sense...

Thanks
 
J

John Vinson

My problem lies in updating and adding new records. I'd like to be able to
add a new record via a form and have it update the underlying tables, which
will inturn update my combo boxes used for searching and at the same time.
Click to expand...

If the Combo Boxes are based on the table, you probably needn't do
ANYTHING to have this happen. Just base a Form on the table that you
want to update (or on a query based on that table, if you want to sort
the records or filter them). What specific problem are you having
doing so?

John W. Vinson[MVP]
 
Top