Combo Box update to underlying table

[arios1234]

I have 2 table.
Table 1 is the data I use for the combo box table2
When I select a value from Table 1 the data is stored in table 2

However when I delete a value in table 1 , table 2 does not update.

Can someone help. Been at it for a weeks..

Note. I am not using form but a datasheet..

Thanks

[June7]

It won't. You will have to edit the record(s) in table 2.

Actually, if you have Enforce Relational Integrity enabled in the Relationships builder, should not even be able to delete record from table 1 if value is used in table 2.

[arios1234]

Thank can you recommend a better way

[June7]

Except for Data Macros introduced with Access 2010, cannot have code behind tables. Use forms.

Why would you want to delete record from table 1?

[arios1234]

Thank can you recommend a better way

There are times to change
table 1 when the data is no longer valid



Thanks

[June7]

But the data is already used in table 2. What do you want to do about the record in table 2?

You can just change data in table 1 record. However, this will affect existing records in table 2. Might not be desirable to change history.

Deleting records should be a rare event. If you no longer want the record in combobox list, have a yes/no field in table 1 that can be used to filter records.