<div>
Use a form in datasheetview.<br />
<br />
/gustav
</div>


<div>
I gave them the solution LSM suggested based on Jeff's reasoning.
</div>


<div>
<div class="content wysiwyg-content">
I am creating a parts database. &nbsp;I have the following tables.<br />
<br />
Project <br />
ProjectSystemXfer (Associates Project &amp;&nbsp;System)<br />
System<br />
SystemPartsXfer (Associates Systems &amp;&nbsp;Parts)<br />
Parts<br />
PartsContractXfer (Associates Parts &amp;&nbsp;Contract)<br />
Contract<br />
<br />
The user is requesting to create a Contract. &nbsp;Then they want to add parts in a spreadsheet format. &nbsp;<br />
<br />
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?
</div>
</div>


I am creating a parts database.  I have the following tables.

Project 
ProjectSystemXfer (Associates Project & System)
System
SystemPartsXfer (Associates Systems & Parts)
Parts
PartsContractXfer (Associates Parts & Contract)
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?

I gave them the solution LSM suggested based on Jeff&#39;s reasoning.

MS Access 2007 - Enter data in spreadsheet format

I am creating a parts database.  I have the following tables.

Project 
ProjectSystemXfer (Associates Project &amp; System)
System
SystemPartsXfer (Associates Systems &amp; Parts)
Parts
PartsContractXfer (Associates Parts &amp; Contract)
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?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.