access database

[donnan33]

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?

[Robeen]

I don't see your spreadsheet attached.

[donnan33]

The whole file was too big. I sent a part out of it to view.

the darkers row is the category, then below that are description, task code, vbuild code, and pay rate rows/columns.

when i put in access i want all fields to be there separately but to only click the category then the description. when i pick the description i want it to automatically pop in all the other fields as this data will always be the same. (description, codes, and rate will never change) only quantity will change.

thanks