Stack Overflow
Stack Overflow

Questions tagged [lookupfield]

32 questions
1
vote
4 answers

MS Access 07 - Q re lookup column vs many-to-many; Q re checkboxes in many-to-many forms

I'm creating a database with Access. This is just a test database, similar to my requirements, so I can get my skills up before creating one for work. I've created a database for a fictional school as this is a good playground and rich data (many…
TBinLondon
  • 13
  • 2
1
vote
0 answers

Problem with a custom content type

I've made a custom content type based on the "Page publishing". In this content type, I've also made a lookup field that lists all items in a list (nothing special with that list though) When I use my own user to look at a page made with my custom…
mrmuggles
1
vote
0 answers

Can a SharePoint lookup field be pointed to anything other than a text field?

A lookup field declared in a feature and using the ShowField attribute to point to a numeric column in the target list (Type="Number") doesn't persist the user's selection. Changing the target field to Type="Text" and everything works fine. Are…
Michhes
  • 143
  • 1
  • 7
1
vote
1 answer

How do I get the entity framework to lookup whether related data EXISTS in a related table?

I am working on making an entity framework project more scalable to suit our requirements. The project uses an EDMX file, Entity Framework, and .NET 4.0. The project has globally setup lazy loading. Basically, I have 2 tables: Product …
NightOwl888
  • 55,572
  • 24
  • 139
  • 212
0
votes
2 answers

Work around needing look-up column data for a calculated column (SharePoint 2010)

In SharePoint 2010: I have a master list that pulls several columns from two different lists based on a unique ID. The information that's being pulled in is similar, but being entered by two different people for two different customers and must be…
Sara
  • 1
  • 1
  • 1
0
votes
0 answers

How to return the text value of look up field rather than ID - SQL Query in Marketing Cloud

I am writing a query and when I select a lookup field "Acct/Customer name" the query return an ID (i.e 01111550023423) but when I go on Salesforce the actual field in the UI shows a actual name (i.e John Doe). Do you know a way for me to be able to…
Paulene Ntsame-Assoumou
  • 1
0
votes
2 answers

Suitescript 2.0 update lookup field value

I need to get a lookup fields value from a line item on an SO and then update the corresponding line item in a PO. Fetching the value is not a problem, I'm using newSite = record.getSublistValue("item", "custcol_site", lineNum) to get the value -…
djbrazzy
  • 21
  • 4
0
votes
1 answer

Refreshing a lookup field value after key value change

I have a two tables : DEPARTMENTS (Index, Name) EMPLOYEES (Index, Name, DEPID, DepName) DepName is a lookup value which retrieve DEPARTMENTS.Name using DEPID which references DEPARTMENT.Index. When using a DBGrid displaying the EMPLOYEES table,…
Stalkium
  • 148
  • 1
  • 11
0
votes
0 answers

Django filter F and functions of fields. Filter by comparison between fields with lookups

models from django.db import models from django.utils import timezone import datetime class Question(models.Model): question_text = models.CharField(max_length=200) pub_date = models.DateTimeField('date published') def…
user3697878
  • 65
  • 6
0
votes
1 answer

How to filter a list by a lookup field in SharePoint?

The first form list is "Standard", with a field of "Code"; The second document list is "Attachments", which has a lookup field that can be multiple values of the Standard Codes. For expample: Form List : StandardTitle Code -QAProcess …
Kevin .NET
  • 463
  • 6
  • 9
0
votes
2 answers

sharepoint Online/365 Jquery, Set Lookup Column Not working e.i ($("select[Title='Column']")

I've been doing some work on Sharepoint Online/365 and have got stuck trying to set the value of a lookup or choice column in NewForm.aspx Narrowed my problem down to not being able to set lookup/Choice Columns I have simplified a code on my page…
Paul
  • 13
  • 5
0
votes
1 answer

How do I pass lookup object values into a FetchXml query?

I am trying to filter a lookup field products with another lookup field editorial (my company sells textbooks). I know how to retrieve values from the lookup object but I do not know how to pass them into my fetchXml query statement. function…
Carlos Farmer
  • 67
  • 11
0
votes
1 answer

How can I populate fields with information related to single lookup field?

I'm working on a form 'Enrollment Adoptions' in CRM 2015, specifically with three fields; Product, Component, and Editorial. 'Product' is a lookup field referencing the Product Entity. 'Component' and 'Editorial' are simple text fields to be filled…
Carlos Farmer
  • 67
  • 11
0
votes
0 answers

Lookup Field whose value depends on the value of another lookup field

I'm trying to make a field in Access 2013 where the selection of a set of team members is dependent upon the team that was selected in the same record. I've made the following SQL statement as my Row Source: SELECT [Tech Name] FROM tblTechs WHERE…
DtheHut
  • 51
  • 7
0
votes
1 answer

how to change list column internal name

in sharepoint i have a list, i have a lookup field from another list, lets call my list as FirstList and the other list as SecondList. SecondList -ID -Title FirstList -ID -Title -SecondList -SecondList:ID when i look to…
brtb
  • 2,201
  • 6
  • 34
  • 53
1
2
3