Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
This page deals with both the embedded subform (part of the main CO form) and the full table. Entering data into the CI subform ties it automatically to the CO you are working with. Entering data into the independent table does not. Using the data table is handy for 'priming the pump' and populating complex info into the database. This way, complex locality, Geography and Collecting Event info can be distilled into a Field Number and given to a database trainee as part of a general data entry task.
The Collecting Information line on the Collection Object form takes information from many different tables and strings it together into a single line. Collecting information, Locality, Geography and the plug-in Geolocate all contribute to the information shown in the field.
Subform View:
Expand | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
The Field Number is the kingpin to this line of concatenated data. If you don't already have a field number, you should run a separate query to see if there is already an established field number for the Collecting Info you are working with.Once you know the Field number, just type it into the field and either tab out or click the down arrow to view the selections. Choose the entry you are looking for, and you're done!
Just remember, Locality, Geographic location, Geolocate, Geologic time and lithostrat are all tied to a field number. You must make a new field number if one of these things change.
|
things to know:
Creating new field numbers
Anchor | ||||
---|---|---|---|---|
|
Whichever way you get here, the form is the same and has the same rules. This form has 3 sub-forms nested inside it.
When accessed through the CO form it's a subform with 3 subforms nested into it. Xzibit would be so proud.
The top part of the locality form is a combination of the Locality subform, and some generalized information. These are separated because there are cases where a locality name will be the same, the other information will be different. Instead of creating a new locality each time a collector heads out to that site, or uses a different collecting method, we just tie the unchanging Locality to the more flexible Collecting Information form. We'll dissect the form the order they appear in the above version of the form.
Expand | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
First, you'll want to see if the locality is already in the database. Running a quick query on the Locality table, looking for locality names from the County and State will help, especially if you add a noun (ie, 'Caleb's Quarry, Ibex area, courthouse) in the locality name query field. Or, you can use the wildcard *, plus a search term (then hit the drop down arrow) and see what comes up. Just be aware, this method only finds the search term as the first word of the locality name no matter where you put the wildcard icon.
If you need to add a locality, here's a thorough breakdown of the locality form (accessed by clicking the green + button, or selecting the 'Add...' option from the search results)
|
Expand | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||
This section of the Collecting Info is just below the Locality block. Paleo Context is how Specify 'sets the stage' for each Collection Object. Here we have the method of recording the geological time in which the fossil came from, as well as the rock in which the fossil was preserved.
|
Expand | ||
---|---|---|
| ||
The collectors sub form links up to the all the people listed in the Agent table. To add a collector's name to the |
Expand | ||
---|---|---|
| ||
|
...