is there a way to select a value in list box after selecting a value from another listbox? knowing that the tables from which the 2 listboxes get their data have no association
Sure. You can use a macro, or a trigger to select a value in the other field based on a selection in the former field. (Using a macro or action would be the equivalent of manually clicking that value in the other field)
