Hello,
I am a fairly new user to access and am looking for some assistance with my database.
If you are interested in helping me, it would be greatly appreciated.
Please contact me directly @ cdunn@georgiapecan.com
1. I have two tables. The first is the main table showing (description, location, dateentered, dateremoved, productiondate, lotnumber, firstname, lastname) The second table is a list of products by description. On my form I have a combo box that references to the second table (list of products) which then logs that information into the first table. The problem is that it logs it as the ID number and not the description. How can I change the displayed data?
2. I need to create a report that will show product by description, production date, or lot number. I want to maintain a list (behind the scenes) of all product which is loaded into my database, however, once product is "physically removed" from the warehouse I no longer want it to show up in the reports.
Any help with this would be greatly appreciated.
Thanks so much.
CD