Displaying Information in a different field!! Please Help

[MarkNie]

Hi I hope someone can help me on this one.

I have 3 tables as follows:

tbltracking
tblFundRepActs
tblFundRepDetails

In the tblFundRepDetails there is an action (which is called from tblFundRepActs through a list Box) there is also an auto date column next to the action.

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.

tblFundRepDetails
action = SLA
Autodate = dd/mm/yyyy

When this information is click on your form the date should show in the following:

tblTracking

Attributiondate= tblFundrepdetails.Autodate.

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

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.


Any help on this will be greatly appreciated.

Thanks
Mark

 

[lupins46]

You cannot do these things in a table.
You have to create forms from your tables. You can then use events properties to run code to achieve what you want.

 

[MarkNie]

Hi lupins46

I have a form which shows tblTracking information and a sub form which shows the tblFundRepDetails. The actual Attributiondate in the tblTracking does not show on the form, does this have too?

Thanks for your help
Regards
Mark