I want to search customer details based on National ID.
The customer table is related to this.The structure of the table looks like this.
customer(customer_id, nic, full_name, name_with_initials, address, contact_number, gender)
customer_id is the primary key of the table.
When the user types the National Id (nic) of the customer i want to display the records of the customer in a table or a form.I want all the records to be displayed such as customer_id, full_name etc...
Can anyone give me the coding?