Form that updates/adds to part of database

[Sharkman1885]

Pat,
Under the ID tab there is a text box called "State ID" and I have no clue where that came from. I have also added an add croc button to add new animals to the database. When there is a new encounter, such as a new date and location, but it is for the same animal, the Location ID does not change and all the biological data is saved under one location ID. So for instance if the same croc is handled multiple times over the course of 2 years in different locations, The location and time data is lost when adding in the new time and location.

 

[Beetle]

Here's an alternative example of how to model this based on my previous advice that you have a many-to-many relationship between Crocs and Encounters. To be more specific, in this example, the M2M is between Crocs and Locations, with tblEncounters being the junction table that manages the relationship. A couple things to keep in mind.

1) This is very generic so it would likely need some modification to work for your specific scenario

2) I don't have a clear picture of how your Other Info table should relate to the rest of the data. In this example I related it to Location data, but it may actually relate to one of the other entites.

 

[Beetle]

See how I am? I said I wouldn't confuse the issue and then I went and confused the issue;-)

If Pat's original example was structured m-m and then you changed that for some reason, then that may be the root of why you are struggling to get the forms to work the way you need. Pat has more time and effort into your project than I do, plus a lot more experience in general, so I would say continue down the path you already started and I will drop out (really, I swear this time).