I am creating a parts database. I have the following tables.
ProjectSystemXfer (Associates Project & System)
SystemPartsXfer (Associates Systems & Parts)
PartsContractXfer (Associates Parts & Contract)
The user is requesting to create a Contract. Then they want to add parts in a spreadsheet format.
How do you provide data entry in a spreadsheet view that will allow the user to select a project to filter the system which will filter the parts and add the part to the PartsContraxtXfer with the appropriate keys?