Yes you can have your current Vendor invoices and then create a new Many to Many join table called Project Vendor Invoices.
One Project has Many Project Vendor Invoices.
One Vendor Invoice has many Project Vendor Invoices.
The the Project would have an embedded report of all the Project Vendor Invoices and similarly the Vendor Invoice would also have an embedded table of the Project Vendor Invoices.
There is then a fast way to quickly launch off a vendor invoice to create those join records by landing on a report of projects and clicking to create the join record. Contact me directly by email if you would like some help getting that set up so its slick and quick for your users.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
