i'm create 2 input text form on a page.
1st for company list, and 2nd for contact list for the company (related to 1st input text).
the option in contact list will generate after company has been selected.
so, I need a parameter in 2nd (contact input text) list to include in WHERE clause in SQL syntax to provide contact list only for selected company.
this is for table illustration:
tcompany:
company_id | company_name
tcontact_person:
contact_id | contact_name | company_id
could you give some clue to solve my problem?
thx.