I have created a database in Access 2000 for a condominium development company that allows their salespeople to select the items a person wants in their home (i.e. which bathtub, which flooring in each room, where they want skylights, etc.) and prints out reports for the customer, the developer, and the various contractors.
The initial data entry was extremely complex and there are over 400,000 items to choose from. I just brought all the items in from Excel spreadsheets and appended them.
My problem is that I need to create a way for users to add new items to the database. It is rather complex due to the constraints created by the relationships, so they can’t just willy-nilly add stuff to a table. They need to add it in the right order. A typical item, like carpeting, has 10 different properties. And color is in a separate table, because different types of carpet would have different colors available. And not all rooms can have carpeting, so the rooms need to be specified.
I want to create a wizard for data entry. I could create a series of forms that LOOK like a wizard, but I think a true “wizard” might work better. I thought I saw something on the web or in a book about how to create wizards for Access but now I can’t find it. Can anyone point me in the right direction or suggest alternatives? Thanks.
– Cynthia
