FK is foreign key'and PK is primary key. You need to understand what these 2
extremely important concepts are. I suggest googling them.
Basically, a PK is a column (or columns) in a table that uniquely identifies
a row. A Fk is a reference to a PK from a related table.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"SandraRae2000" wrote:

I'm trying these things you suggested, but what is FK?

"Fred" wrote:

Do what Jeff said.

Adding / reinforcing the fine points, start by pushing your Access book and
the computer aside and decide on what the ENTITIES that you want to database
are, and what the relationships are between them. You might even discuss
that further here in this forum at this early important stage.

My first guess is that main main entity is dtatsets, which are instances of
receiving data, or, more specifically, instances of data being recorded or
summarized by your sources.

"Sources" will probably be another major table. If so, a good guess would
be to put a SourceID autonumber PK field in your Sources table, and an
integer "SourceID" FK field in your Datasets table and link those two fields.

"Hazards" will probably be more of a "lookup table" to fill a "hazard" field
in your Datasets table.

Good luck!