We are currently looking to collect a wide array of data on individual subjects at several data collection stations. Because of this, we have taken a single table, and have built several distinct forms off of it in order to split the data collection between different computers. For instance, on a single football player, one station may record height and weight, while another station records position and running speed.
However, when we try to do this, despite having the same primary field, we have multiple records for each sample, looking something like this:
Despite the fact that the sample in the primary field the same individual, using two forms to fill in data is causing a repeat of the individual’s entry. Is there a way for us to have the table fill in so that it looks something more like this:
We are really looking for a way to get separate forms on separate computers to fill in fields on the same data entries on a single central table.