I used dependent dropdown boxes, where values shown in the second dropdown box depend on the value that I have chosen in the first one. This works perfectly in the add record, but on edit or copy , the value of the detaild field is not showing at all. It really drive me nut.
Here is the senario. I have 3 tables, transaction_category, transaction_type and transaction . The detail table transaction_type is depend on the master table transaction_category and both are look up tables when I add,edit ,view a transaction record in the transaction table. I set the transaction table so the field transaction category and transaction type are the look up wizard and the transation type is depend on the transaction category. It works wonder when I do the addnew, the lookup works fine , and store the value in the database. Now when i call that record again to edit it , the transaction type is not show , I can not drop down the list either.
Please help , please let me know if I did not state the problem clearly
Thanks
Bill
