hi,
i can add record sucessfully... but cant view it accordingly wen i press navigate buttons in the form...
please help me to solve this.... db is attached
thanks in advance
Table Name:Customer Status
Fileds:
: SID - (Auto Number)
: CID - (Customer ID is Link to customer Details table's CID)
: Name
: Status (Suspended / Active / Terminated)
: Date
Above are the fields of my customer table and i just wanted to know how to get lastest status of each customer...
someone kindly help me on updating Table1 status with the last updated result of table2 status.
EG: there are many times we suspend each and every customers so i need to update status frequently therefore when i view a customer id in table1 the status should be = to the table2 status filed...