Hello,
I have a excel table as shown below, in which I want to view this table when am entering a data into Access form to fill only one field in a form and remaining Fields are filled Manually. So I am thinking to create a Linked cascading combo i.e for Eg: when I select B -->Option1--> data(B Column) -->*******
Has (*****)to be selected , only (****) has to be inserted into Table(Everything is done in Access 2010)
so my questions are
1) Can Linked cascading combo can be designed in Access ?
2) If yes, How to do so?
3) If No, which approach has to be used?
Thanks in advance