I issue multiple RFIs (requests for information) for multiple projects. The trouble that I have is that I am having to make a table for each project, which means that there is a lot of work for each new project. What I would like to do is setup a table that allows me to enter the RFIs and and then run a query based on the project number and have the query issue a sequential number as the RFI no. This will allow me to change all of the forms and reports based on the data. Any suggestions would be really appreciated. I use the RFI and project number together. PROJECT.RFI.Seq# HFF.RFI.001
RFI No. RFIProject RFIDate RFICompany RFIPOC RFISubject RFIIssueLocation 001 HFF
9/11/2015 ABC, Inc. Person Thermostat: Proposed Location
Back-of-House Wall South of Reach In Freezer 1
RFI No. RFIProject RFIDate RFICompany RFIPOC RFISubject RFIIssueLocation 001 LESCHI 11/13/2015 XYZ, Inc Person 2 Floor/Ceiling Assembly Between Retail and Living Space Floor/Ceiling Assembly Between Retail and Living Space 1
Sample RFI Form
Thanks for looking.......