Hi there, another newbie here, trying to move from Excel to Access to control my antique shop. My (current) problem is how best to provide a means to enter data about new stock into the db? If I buy an item, I want to record several pieces of information about it (where purchased, date purchased, price etc.). I'm using combo boxes to populate each column in my stock table which is OK for individual items but if I buy 10 items from one place on the same day then I have to select that place name etc. 10 times….. Is there an easier way?
Thanks
Nick