Search results

Thanks Beetle! Sorry I have been having a bit of an issue grasping, or rather recognizing, some of the core concepts. Ill be able to check back and respond to your suggestions on Monday or later today.

Yes croc data is taken statewide. However even if say croc 5 is seen multiple times at location A, the dates of the croc being seen would be different. This would mean that even though the location would have multiple crocs over a given time period, there would be only one to very few at any...

Your assumptions are indeed correct. I am confused with this explanation though. Each encounter also has a date associated with it on the table (which is why it is called encounter and not location) so even if multiple crocs show up at different times at one location that is still considered...

Hey Beetle, For your first inquiry the answer is A. The reason is we want to be able to look back at the history if needed. I thought that too originally, until it was pointed out to me that one croc can only be at one place at one time. though a place (encounter) can have many crocs at the...

Beetle, Forgot to actually address my original question. Is there a way to have a button change the form to one which you can enter new information for part of it. For instance we recapture a croc but have to update location and biological metrics as well as the SNAP reference. I wouldn't want...

Hey Beetle, Thank you for the response and sorry for my late reply as I has having issues connecting to the forum's server this morning. Ill do my best to answer each of your questions about the design of the database and give reasons why they are the way that they are. Ok your first question...

Hey All, Is there a way to make edits or partial updates to a database using forms? To give an example of what i am after, lets say a new croc is tagged. That croc would have a brand new entry since he/she was never tagged before. If a few months later the same croc is seen in a canal somewhere...

Your changes work perfectly! Unknown sex will stay null value so the query will always include unknown sex. The mixing of the data was most likely from a bad join or relationship that I had. Thank you again for the normalization. Ill have to go back and fix my original database and make sure...

Thanks Pat and will do. As far as the sex goes they are sometimes unknown, if the croc was hit by a car and beyond recognition or if the biologist didnt have the tool required to sex the animal (cloacal probe) it would be unknown.

We do try and get accurate GPS locations but sometimes we use an individuals address to get an approximate GPS. Most times a crocodiles location is referenced by the neighborhood that they are in. Because of that I think I will place the date/time in the encounter table. You guys are life...

Ok thanks guys. Ill work on the tables a bit more.

So are you saying to combine the biological data with the encounter data and put the location data (GPS ect) in a separate table? Im not sure I understand. In your example above you included biological measurements in the encounter table. Each encounter happens at one location but not every...

Plog, There is not biological information taken at each encounter as some encounters are just sightings. A single location can also have multiple crocodiles. Without the CrocID FK in biology and other info the query returns the wrong data and 10 times the returns it should. With the CrocID FK...

Oh and Pat, I tried your suggestion but it messed up the queries. It was mixing data from tables.

Sorry for the delay all. I got a bit busy at work. I should have everything working correctly, and normalized.

Ok while looking at this relationship further, I dont have an identifier FK for location. I can go in manually for each croc and add one if you believe it is necessary and it may be, the more I look at it the more I am beginning to think that adding that FK is the way to go.

Pat, I checked the relationships. When I clicked on "All Relationships" nothing unexpected showed up. I also created a relationship report and nothing unexpected showed up either. I am not sure if I need to change the relationship as the sightings are of the crocodile itself, the ID...

Ok question I am trying to make sure my tables are correct. The title of location has not been changed yet. Under Biology and Otherinfo it is not letting me remove CrocID as it is one of the indexes. I have attached to relationships and also included my INNER JOIN code FROM (((Crocodile INNER...

Quick update. I have rectified the date issue by creating a single date field in Location, still need to change that table name. Changed the coding of my query to reflect the change and everything still works. Checking the Joins in the query, which is where I may have some issues but hopefully...

Pat, I will most likely keep the biology and sightings separate. As far as the narrow scope, the only crocodilian we keep track of, as far as tag and release, are crocodiles. Caimans are invasive in Florida, and Alligators are regulated via hunting, trapping and farming records. I would be happy...