• Registered: 02/23/2013
  • Posts: 16

Topic: Search by Branch

I would like to be able to search by branch when I don't know who the customer is.

I maintain aircraft, and each registration number is a branch; a customer may have several aircraft. Often, I can't recall what the customer name is, though I know the branch name (simply by looking at the airplane in the hangar).

Can this be done?


TIA

Chris

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,150

Re: Search by Branch

Would References, Dimensions and / or Tags do?

apmuthu's Website

  • Registered: 02/23/2013
  • Posts: 16

Re: Search by Branch

Apmuthu - I see where this could be used, but it is quite cumbersome; would be quicker to make a spreadsheet with all customers/branches.

I suppose I could write a short php script to mine the mySQL tables directly.

Thank you for the input.

  • janus
  • New member
  • Offline
  • Registered: 09/18/2014
  • Posts: 6

Re: Search by Branch

Hi chrisklinger

I saw this query and was wondering if you managed to overcome the challenge with regards to searching a "branch" only.

Let me know please.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,150

Re: Search by Branch

Make the Aircraft as the Customer and the Contact Person as the Real Customer to be billed. Better still, make the Aircraft RegNo and the Customer Name concatenated into being the FA Customer.

If you wish to mine the branch table, use, phpMyEdit.org / Adminer.org or some such CRUD program for a quick and effective job.

apmuthu's Website