I am trying to relate two tables. One table is incidents and the other table is offense. I'm trying to query for burglaries in a city but the tables don't appear to be linking correctly. When I link certain fields such as case number it state indeterminent (one is incident case number and the other in offense case number. There is one field that appears to link incident link and offense link but no matter how I link it the data doesn't show up correclty. Any suggestions?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Relaltionships
- Thread starter Abner2
- Start date
Post you table structures for use to see what the problem may be...
****************************
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)
Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com
****************************
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)
Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com
- Status