I have a site "ABC Company" in which I have two subsites.
- HR
- Inventory
In HR subsite there is a list "Employee" which has a column "Full Name"
In Inventory subsite there is a list "Issue Inventory" which has a column of "Employee"
I want to bind lookup column in Inventory->Issue Inventory list with HR->Employee list.
Please advice how can I do this without using InfoPath. Its possible in InfoPath but InfoPath changes the look and feel of page thats why I want to do this either using sharePoint web environment or sharepoint designer.