This is my scenario
I have a list of clients on the root site collection. www.mydomain.com/lists/clients
I have 17000 clients on that list.
Then I have other site collections, where I want to have a lookup field to the client list in the root site collection. I know that by code I can create a lookupfield pointing to another site using the webguid.
I want to create an autocomplete field, simple select and multiple select with SPServices and showing multiple columns.
I am totally new to the SPServices world so I would a little bit of help with it.
- Do I need to create a custom field type for this?
- If not, then how can I attach that it shows the auto complete field for some specific lookup fields? This part is important to me, because I have 17000 site collections, and inside those site collections I will have multiple document libraries with a lookup field to the client list
Any source code to see an example of how to do it?
I saw this video http://www.youtube.com/watch?v=wXYDBm28W_c&feature=endscreen&NR=1
It looks like the thing I need, but how can I inject that code in the NewForm.aspx specially if I have 17,000 site collections and on every site collection I have 50 document libraries where I want to have the autocomplete.