Given:
One table with following fields:
System, Component, Anomaly number, Status, Priority.
I have a form with first two fields as system and component. You can select each with from drop down menus.
Question:
I would like to create more fields in this form, where I can choose system and component and display anomaly numbers associated to them and their respective status and priority.
I can do this in excel using VLOOKUP. Tried using DLOOKUP in access but cannot get it to work.
Please help. Also, I am newbie using Access, so keep that in mind if you find my question to be very basic.
Regards,
D