MS Access 2007 - Enter data in spreadsheet format
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?
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?
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I gave them the solution LSM suggested based on Jeff's reasoning.
Microsoft Access
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.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
/gustav