Hello,

I have two tables RFI Log and Event Req.  Both tables have the field 'Event
No'.  A RFI field is under both tables. Under RFI Log the field is named 'RFI
No'.  Under Event Req. table the are multiple RFI fields: 'RFI No1', 'RFI
No2', 'RFI No3' etc.  I also have created two data entry forms, one for the
RFIs and one for the Events.  What I want to happen is when the RFI No is
entered into the Event Req form it updates the RFI form. Example Event= 500;
it has RFI No1= 120, RFI No2= 200.  When the RFI form is brought up. under
RFI 120 the event field has 500 and under RFI 200 the event field also has
500.  A simple join under the query doesn't seem to work....Any ideas?

Many thanks.
Max