Results 1 to 2 of 2

Thread: Search

  1. #1
    Join Date
    Dec 1969

    Default Search

    Hi how do i search my database which has realtionships in it. For example one customer has many addresses, one address has many equipment and one equipment has one maintaince schedule and one equipment. So if i was to do a search query using drop down menus for example searching for lets say a particular peice of equipment, i would want it to display all the records with that particular peice of equipmemt. Any ideas any one im really stuck in the mud. Thanks<BR><BR>Sal

  2. #2
    Join Date
    Dec 1969

    Default The general answer is you need to learn

    SQL and particularly about "joins". I suggest starting with the help file of whatever db you are using. I&#039;ll bet you are probably using Access, if yes then simply go in the help and lookup "Jet SQL" and go thru the examples. <BR><BR><BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts