I have Projects that can create Work Orders directly but also have an intermediate table that creates records sometimes from Projects called Work Projects that I also create Work Orders. I need to have the Work Orders records added from Work Projects capture the Project relationship from the Work Project. I can pass to the Work Order form the Work Projects - Project_Name (text proxy) but that does not create the relationship field value for Work Orders - Project_Name. I need this same solution for a number of table record combinations. I really need to do this with the inherent capabilities of Quick Base. I've tried setting up a many to many but can't figure out how to accomplish this with so many tables and records in this app.