HI Guys,
Can anyone help me ?
I have two tables. Asset Register and Asset Tracking
In asset tracking i got one field asset Status (which is dropdown : In, OUT, Lost , Stolen Damage) which i am talking from Asset Register table
but when i add any entry it does not update into asset Register table.
if anyone can advise me better design.
Asset Register is table design to contain all the records related to Asset such as when it is IN,OUT,Lostand Damage.
Asset Tracking is table design to keep track of asset such as issued to but it does not have asset status field because i think i can add asset status field from asset register table (in Query page in asprunner 6.1 using add other table and select asset status field) .
so that if i am going to issue any asset i will add name into asset tracking table and select asset tag and asset status from asset register table.
and if some one retuns it. just edit asset status in asset table to retun and it should update into asset register table.
if any one have any better idea of handeling will be appericated