Connecting Fields in tables

[MarkNie]

Hi I hope someone can help me on this one.

I have 3 tables as follows:

tbltracking
tblFundRepActs
tblFundRepDetails

In the FundRepDetails there is an action (which is called from tbFundRepActs through a list Box) there is also a auto date column.

What I am trying to do is when I click on the action column in tblFundRepDetails and choose and action such as SLA the autodate will appear and I want that date to appear
in the same actionnamed (SLA) column in tbltracking.

If a user makes a mistake and has to delete the action the date must be deleted from the actionnamed column in tblTracking.

Any help on this will be greatly appreciated.

Thanks
Mark

 

[randysmid]

Wow,
That was very confusing!!! Are you doing this in a form? What exactly is an "action column"? What is "SLA"? What version of Access are you using?

 

[MarkNie]

Hi randysmid

Well it does all sound very confusing I will try and explain a bit better.

The action column is just a drop down column that you can select an action from such as SLA which is one of the actions in the drop down.

The version is 2000.

This all does happen in a form when you select the SLA an automatic date appears next to it which is the one I need to copy.

I hope this help let me know if you need more info

Thanks for your help
Regards
Mark