I am creating a Risk/Issues database for a construction company I work for. Within this database, there is a table for Issues, RFIs, & Change Orders so that each Project logs the above related information and creates all the associated reports.
I have most of the database constructed without too many issues but have came across one thing that I can't seem to find or get established.
In theory, Each RFI requires an Issue but an Issue may have more than one RFI and Each CO also requires an Issue. Issues may not always have an RFI or CO.
I would like to have a way of ensuring that each new RFI &/or CO is assigned to an Issue. Is there a way to code this?