Last post Jun 03, 2014 03:01 AM by Kevin Shen - MSFT
May 31, 2014 12:28 PM|Rebin.O.Q|LINK
I have two tables (one to many)
Table Sudent (SID,FIRSTNAME)
how to link tables in jQuery autocomplement, for example user type student name on (input field student) then select a student after that user want to select book of student from (input field book)
my jquery code
$( "#studentinput" ).autocomplete(
$( "#bookinput" ).autocomplete(
in html code
<input type="text" id="studentinput" placeholder="Student" />
<input type="text" id="bookinput" placeholder="Book" />
Thank you :)
Jun 03, 2014 03:01 AM|Kevin Shen - MSFT|LINK
For your post,Here are my suggestion:
First ,you need to use jquery ajax to get the studentinput value.
Second ,you need to use jquery ajax to get the bookinput which value based on your studentinput value.
Here is a link which provide a demo explain how to create a cascading autocomplete step by step:
This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore,
Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you
completely understand the risk before retrieving any software from the Internet.