This is question isn't a specific problem but an index design query.
I have developed an Admin database that produces project info, quotes on the project, itemises them assigns manpower and cost codes and links costcodes to a PO table this is relational through several one to many relationships...