All,
I hope this is an appropriate place to post my question, if not, please point me in the right direction.
I use access everyday, but have only begun to scratch the surface of its computing power. I enter data in the only table in the database, which I have read to be less then ideal. Each line item corresponds to a physical asset in our warehouse, and catalogues all of its pertinent information, which includes serial numbers, ownership information, services and fees.
My question is: how do I orchestrate the automatic population of cells based on the content of other cells? ie if the customer computer had one particular service done to it, I want the inbound and outbound hard drive serial numbers to automatics fill and match, and the correct fee to automatically fill.
Side note: I have learned only through trial and error, and Google. Any suggested resources would also be welcome.
Thank you