I am a biologist and am working in a FMP database that allows me to log surveys (date, time location etc). For each survey though I have multiple GPS locations to enter for any specific resources that I want to map. For e.g. a certain plant. If I wanted to list all the locations on the survey that I found a specific plant, how would I enter the list of GPS locations and have them connected to the survey record?
What is the best way to go about entering this data so that I can easily then extract it later for use in Google Maps or GIS? any tips most appreciated! thank you. Paola