Working with two tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You need to change the table design. the EventReq table should have only a
single RFI field. So rather than having multiple RFI fields in one row,
each RFI will end up in a separate row.
 
Back
Top