How to set different lookup for select / dropdown box between insert/update

Code Examples Form
#1

Hi,
I want to set different lookup query for dropdown box between insert and update mode.
For example, when I click add form, the dropdown box will use table A, and when I click edit form, the dropdown box will use table B.

Is that possible?

Thanks