Table Relationships

[MadCrazyNewbie]

Hey Group,

Sorry i know i`ve asked this before and got loads of responses but im
confused as to what to do

I have a Table:

FaxID(Primary Key), Serial, Make, Model, Department(Lookup Table),
Site(Lookup Table).

I would like to be able to have another table of Meter Reading. Our meter
reading is taken as intervals no of which wich have a pattern, some may be
taken every month others may be taken every 3, some others every 6.

I`ve now created a Second Table:

FaxMeterReadingID(PrimaryKey), Date, Reading

Now how would I link these 2 tables together? - Would it just be a case of a
Many-toOne relationship with FaxMeterReadingID and FaxID?

Any Help or a Step by Step Guide would be appriciated.

Many Thanks
MCN

 

[Van T. Dinh]

You need a extra Field:

frg_FaxID ForeignKey from the tblFax

(as per my previous post)

in the second Table which is the linking Field between the tblFax and
tblReading.

Check Access Help / Access books on relationships, in particular,
One-to-Many relationship.

 

[MadCrazyNewbie]

Van,

Thanks again for you reply:-

Ok so now i`ve created a FaxReadingID on my (Faxs)Table.

On My Second Table (MeterReadings) i`ve create a FaxMeterReadingID(Primary
Key)

Now do I link these two together?

How do I do that? Sorry Im a Newbie.

Many Thanks
MCN

 

[Van T. Dinh]

Please re-read my replies to previous thead.

I think you got the ForeignKey in the wrong Table. With the FaxReadingID in
the tblFax, you are trying to establish the FaxReading as the "One" Record
and the Fax as the "Many" Record. You need it the other way around!

Have you checked Access Help / Access book? Access Help / Access books
cover the One-to-Many relationship pretty well.