First, I assume I am in the right section for this question. I am brand new to Access and have basic knowledge about how to design the files, forms, queries, and reports. I am not current on terminology and do not know how to program. I did work for a software company for many years doing needs analysis and design work, but no doubt that industry was very different 40 years ago. At least I am not scared to try anything, but I will sound clueless because that is exactly what I am.
My approach is to start with the collection of a single type of data and try to get it as close to what I think I will need throughout the rest of my design. I work with numerous types of contacts. I would like to have the first field in a contact form to be a lookup field. After the field is completed, then I would like my form to change to the appropriate form for that industry so I can only see and enter the specific data I need. Thereafter, when I go beyond designing the contacts, when I add that contact to a "Case," I want the contact form based on the contact type, the specific contact form, to be the default.
Can I do this in Access and, if so, how is that done or can you point me to some place where there is information suitable for a person who knows absolutely nothing about this product or programming? Any input on KISS resources would be great. I don't have any software buddies so it looks like you guys are it. I have difficulties with reference materials because they all assume I have knowledge that I do not. I need the dummies version. Thanking you in advance, Rachael