Need help with DB design

[Joel]

Here is what I need to do.

I need to store the owners info, there location, the areas in that location,
the buildings in that location, the structures in that building, the
condition of those structures, the inspection history,the findings of that
inspection, the repair info for that structure and the history of the repairs.

I have tried a few different DB setups and I cant find a way to link all
that info into a report.

Any help would be very much appreciated!

Thank you in advance!

 

[Brian]

Your request is fairly expansive, so here is a general idea:

Table: Owners
Fields: OwnerID (Primary key, AutoNumber, Long Integer), OwnerName (Text),
Location (Text)

Table: Locations
Fields: LocationID (Primary key, AutoNumber, Long Integer), OwnerID (Long
Integer), LocationName (Text)

Table: Buildings
Fields: BuildingID (Primary key, AutoNumber, Long Integer), LocationID (Long
Integer), BuildingName (Text)

Now set these relationships (Enforce referential integrity at least, and
perhaps Cascade Update and Cascade Delete):
Owners.OwnerID -> Locations.OwnerID
Locations.LocationID -> Buildings.LocationID

etc., etc., etc.

Then create these forms:

Owners: ControlSource is Owners table; include a button that open the
Locations form

Locations: Control Source is:

SELECT Locations.* FROM Locations WHERE
(((Locations.OwnerID)=[Forms]![Owners]![OwnerID])) ORDER BY
Locations.LocationName;

Thus, the Locations form only shows locations pertaining to the owner
selected on the Owners form. Make a similar relationship between Locations
and Buildings, etc. Then, you can create a report to pull the info for just
one owner, one location, etc.

Hope this was some small help...much more than this, and you'll probably
just have to hire someone to write the DB for you.