Can one update or insert recordset to junction table or current fo

[FerryMary]

Using Access 2003

Working Vessel Maintenance Database

With help from (actually the code was written for me by)Chris, I have the
makings of exactly the database I want. From studying and the training
sessions I've decided to go ahead and set basic tables for all aspects of the
department rather than just the invoice-type section. I've possibly gone
overboard on the indexing. Right now based on the indexes I've created I can
not imagine a search I could not perform.(except possibly casualties as
related to shoe size of the captain) ;-)

What I'd like to acheive is returning the value of a recordset to open form
or a junction table to show it relative to that record value. I'm sure my
inexperience is hampering efforts here. Here is an attempt to make it more
clear:

I'll leave out tables not relative

Table #1 is a Vessels Table with fields: VesselID(pk), NameVessel,Class(fk)

Table #2 is a Vessel Reports Table with fields:
ReportID(pk)VesselID,DateReport

Select Query consolidates VesselID,DateReport as "yy",and count of VesselID
report
(I've explained that horribly but it returns exactly what I want it to) as
Fields: Name Vessel and ReportInfo(which is the designation I want associated
to each record)

Since this Query returns a unique value that should not be able to be
reproduced is there any way to generate it directly back to Vessel Report,
VesselReportsDetails or a junction(?) table with fields ReportId and
ReportInfo? and have it as a primary key?


Thank You-y'all are the greatest resource I've found yet