nusilmar
Member
How to have a field that automaticaly checks changes on another field and update itself ?
I have a table1 with this setting :
id, date, software type (DBJ to a software type table), software ( CCD to a software table watching software type), version ( this is all the versions released of a software)
On this table i can have several software versions for several softwares but only one version is the current version, per software)
And a table 2 with this setting:
customer ( DBJ to customer table), software type (DBJ to a software type table), software ( CCD to a software table watching software type), version ( CCD to versions table watching software) , iscurrent ( yes/no field)
My main goal is to have the field iscurrent on table 2 to be automaticaly updated every time a certain software gets a new version, so that it shows on that field if the customer have the latest version.
I have a table1 with this setting :
id, date, software type (DBJ to a software type table), software ( CCD to a software table watching software type), version ( this is all the versions released of a software)
On this table i can have several software versions for several softwares but only one version is the current version, per software)
And a table 2 with this setting:
customer ( DBJ to customer table), software type (DBJ to a software type table), software ( CCD to a software table watching software type), version ( CCD to versions table watching software) , iscurrent ( yes/no field)
My main goal is to have the field iscurrent on table 2 to be automaticaly updated every time a certain software gets a new version, so that it shows on that field if the customer have the latest version.