I have a spreadsheet with 6 columns. I need to put in access. Only 1 of the columns needs the data entered. I need all the other four columns to still show up with their data.
Category
Description
Task Code
Vbuild Code
Unit Quantity
Payout Rate
How can I click on the Category and all other fields data that is under that Category is automatically inserted in the proper fields without having to click from a list on enter each field? That data will always be the same for that code, description, category etc. They will just need to enter the Unit Quanity. I need the report to show all the fields above. I have Attached my spreadsheet. I need the entry person to click the category and all other information that goes with it is automatically entered. then they enter qty.
can anyone help with this?