Look-up field problem
Posted: 2019-02-03 19:15
Hi everyone, this is my very first post and I a still have a lot to learn. I have an all_contacts table with a field called contact_type with these list values - Customers, Friends, Leads & Others. In my customers table I have a lookup field to all_contacts to look-up customers. The following code - SELECT `all_contacts`.`contact_ID`, `all_contacts`.`company` FROM `all_contacts` WHERE `all_contacts`.`contact_type` = `Customer` ORDER BY 2 is not working.
The default query - SELECT `all_contacts`.`contact_ID`, `all_contacts`.`company` FROM `all_contacts` ORDER BY 2 works fine but of course I than get all of my contacts instead of just the customers. In my application when I click on my look-up field nothing shows up at all, I just get the message "Searching" with that round twirling image.
Thanks in advance, I truly love using and learning AppGini. The most important software I use to manage my business.
The default query - SELECT `all_contacts`.`contact_ID`, `all_contacts`.`company` FROM `all_contacts` ORDER BY 2 works fine but of course I than get all of my contacts instead of just the customers. In my application when I click on my look-up field nothing shows up at all, I just get the message "Searching" with that round twirling image.
Thanks in advance, I truly love using and learning AppGini. The most important software I use to manage my business.