Search on two joined tabled
I have a table structure:
Table: Itineraries
ItineraryID (PK)
Itinerary
LodgeID
etc
Table: Lodges
LodgeID (PK)
Lodge
etc
Would it be possible to have a search that included the Itinerary field from the Itineraries table and also the Lodge field from the Lodges table that returned Itineraries where Itineraries.LodgeID = Lodges.LodgeID?
Ie people looking for a Itineraries that included nights at a particular Lodge?