I tried searching before posting but I guess not getting the correct answer.
I have two list:
Created By Value
Ok, my requirement is, when I click on add new item in List B, based on the current user who is logged in (for example, created by value in List A), the value of Value Column in List B should get auto populated.
So say I am user ABC and I clicked on Add New Item in List B, I would get
Value = Value1
As of now I haven't decided any approach (like infopath, workflow, etc) I am open to use any of them, but not sure what I should be doing to achieve this, any idea guys?