Why does table4combo update old record table?

[Craig at a casion]

When I update a table used for the combo boxes on my form,
Access changes all my old records.

Put in another way.

I have a thousand form enries with the following data or
fields.

Location, Serial#, Model ID,...

Each field uses a combobox to help fill in the form.

Each entry or coloumn is bound to a field in a table with
the same name so I can view, filter and analise the data.

When I have to update the table that I use for the combo
boxes I notice it also updates all my old records and
leaves blanks in the form view for any fields that can no
longer be found in the combo box table.

I have not set any relationshis yet.

I have played around with the bound colomns but had it did
not work.

So I;ve been using this for a long time now.

 

[Jeff Boyce]

Craig

Based on your description, I would guess that the reason you are seeing
"old" records changed is because the database is designed relationally, as
is appropriate for Access. If the description of a "Model", tied to a
ModelID, is changed, then any table using the ModelID will, by referring to
the lookup table, see the new description.

If you are saying that you need to keep old/historical records with the
original values, you can't be changing the description(s) in the lookup
tables. Instead, consider adding new rows in the lookup table(s), and
"end-dating" the lookup rows that are no longer valid (but are being kept
for historical purposes).