Hey all I am working on a database for a tabletop campaign game and I am stuck. I have two table one is "unit" and contains all the information on a unit, types of equipment and etc. the second table is "location". This table holds the locations for all of the units.
Table "unit" contains the following fields
unitid(primary key)
unitname
equipment
Table "location" contains the following fields:
recordnumber (primary key)
unitid
unitdate
unitlocation
the table are joined in a one to many using the unitid field
I want my query to show the most recent locations for all units.
Thanks for any help.
Table "unit" contains the following fields
unitid(primary key)
unitname
equipment
Table "location" contains the following fields:
recordnumber (primary key)
unitid
unitdate
unitlocation
the table are joined in a one to many using the unitid field
I want my query to show the most recent locations for all units.
Thanks for any help.