i have a set of databases (houses, rooms, artifacts). i need to search and display records for multiple criteria. for example,
display all rooms of type 14 with skeletal and ceramic material
or
display all houses with room type ala that also have triclinia
i know how to relate the house/room databases to display the appropriate room and i can find the artifact materials separartely but i don't know how to do both in filemaker. i know how to do it in sql and access but the databases are in filemaker and i have to use it to do this project.
can anyone direct me on where to look?
thanks much.