i have a customer table with the following fields :
code : this should be generated automatically
I want to create a form to add, edit, delete and view the records. when a new record is added, the user has to choose between domestic and export (option group), and based on the selection a list of all the export or domestic countries/states are displayed from separate tables in a combo box. The other combo box is accordingly disabled. The customer code is then generated. How do I go about this. Please help.