Questions tagged [lookupfield]
32 questions
7
votes
1 answer
How to create a TDataSet Lookup Field at runtime?
I'm using TADODataSet (D7).
I do not create persistent fields in design-mode with my DataSet.
dsItems.CommandText := 'select ID, ItemName, UserIDCreate from Items';
dsUsers.CommandText := 'select ID, LoginName from Users'; // lookup dataset
If I…
Vlad
- 1,383
- 14
- 29
5
votes
1 answer
Programmatically generated Lookup Field causes "System.ArgumentException: Value does not fall within the expected range" when creating new item
I created a content type TypeA that has a lookup field to basic ListB. Then I create a ListA that uses TypeA. Everything is created programmatically.
An exception is thrown when ListA's 'add new item' modal is supposed to load. It only happens when…
Kache
- 15,647
- 12
- 51
- 79
3
votes
1 answer
Replace Default PK slug with Multiple Lookup Fields for ModelViewSet
I have two slugs, against which I run queries. Thanks to base class MultipleFieldLookupMixin, which my view class is inherited from and thus allows me to have multiple lookup_fields.
We know that when ModelViewSet is used with DefaultRouter, appends…
Muhammad Naufil
- 2,420
- 2
- 17
- 48
3
votes
3 answers
How to create LookUp fields in DataGridView?
In my DataGridView I'am displaying a buch of columns from one table. In this table I have a column which points to item in another table. As you may already guessed, I want to display in the grid in one column some text value from the second table…
Wodzu
- 6,932
- 10
- 65
- 105
2
votes
2 answers
How do I filter choices from a lookup field that points to a different SharePoint list?
I have an app built based on the a SharePoint list called "Proposal Tracker". One of the fields is a lookup field that provides a drop down from another list called "Employees". I am trying to filter this field, so that when I select it, the only…
kriand0322
- 21
- 1
2
votes
0 answers
Issues using a custom view on a Subgrid for a Lookup in Dynamics 365
I am working on a form where visibility of a certain section is based on a specific field on the form. The section in question also has a subgrid ("WorkingDataRequestsGrid"). The logic for displaying the field is working fine. However, it is not…
Paul Haan
- 101
- 10
2
votes
1 answer
what is RowOrdinal property in Sharepoint FieldType Definition
In Sharepoint it is not possible to add more than 16 Lookup-Fields to a single list.
This limit is explained here: http://support.microsoft.com/?scid=kb%3Ben-us%3B823555&x=6&y=5
I found a workaround for it: The RowOrdinal-Property in FieldDefinition…
Björn Mühlhoff
1
vote
1 answer
Problem with Sharepoint ContentTypeBinding and Lookup field
I have a problem with ContentTypeBinding when creating a new site. I have custom site template definition where I have referenced Publishing Server Feature, so list Pages is automatically created on site. I need to bind custom content type to OOB…
Michal
- 1,324
- 2
- 16
- 38
1
vote
0 answers
Set null value in Filter Lookup field in dynamic 365
In my D365 Project I want to set "No Record Found" in filter lookup field.
I have created lookup field. In that field I called JavaScript and filter that lookup which is working properly but when records are empty it was showing error like…
Kalp Shah
- 279
- 2
- 14
1
vote
1 answer
Azure Data Factory import multiple valued lookup fields
I need to import data from Sharepoint online list using Azure Data Factory in SQL Azure DB.
The share point online list contained a fields of Lookup type, with options "Allow Multiple Values" ON.
I use Azure Data Factory as tool to copy data from SP…
ADF Admin
- 11
- 1
1
vote
1 answer
executing a caml query to get a lookup field : "Cannot complete this action.Please try again."?
It is my caml query code to get the value of a lookup field in SharePoint 2016 on-premises (CSOM).
…
hossein hashemian
- 311
- 2
- 11
1
vote
3 answers
How can I programmatically get Approval Status in SharePoint?
I wanted to programmatically get SharePoint Page Approval Status, I tried as below
public string GetApprovalStatus(string url, string listName, string fileref)
{
string result = string.Empty;
string caml = @"
…
sams5817
- 1,037
- 10
- 34
- 49
1
vote
1 answer
Maximum lookup fields in a list
In SharePoint 2007, is there a limit to the number of lookup-fields that you can have in a list?
Tato
- 139
- 1
- 7
1
vote
1 answer
How to Create Lookup Field in Sequel Pro?
I have a table with a primary key lbxProgID.
The FK is lbxClientID that references a clients table.
zoom in of fields in question:
Currently when I want to add an entry to this table, I need to know the actual integer ID of the client so I can add…
DW33
- 11
- 4
1
vote
0 answers
Microsoft Access Web App Lookup fields not displaying in List View
I have built a Web Application in Microsoft Access.
For some reason, in my list views, the fields that are lookup fields are not displaying at all.
They do display properly in the datasheet view.
While this doesn't necessarily hurt the functionality…
Heather
- 11
- 2