Topics Search

Removing a lookup field from a table

Removing a lookup field from a table
Views: 3
I'm working in Access 2010. This is essentially an HR database intended to track training and job postings. I used a lookup in my Postings table to identify type of posting, eg. incumbent, relief1, relief2.

I want to print a report that lists employees down the left and shows their posted positions under the relevant "type."
Sponsored Links:

Similar posts...

 

Lookup for a field using only unique values.

Lookup for a field using only unique values. Icon
How can I set a field in a table as a lookup, but only get the unique values from the table that is being looked up?

For instance say I have a table that consists of three fields, A, B and C as below.

Table 1:

A B C
1 2 3
1 1 1
1 2 2

Now, say I create a new table with fields called X and Y, as below.

Table 2:
X Y

What I want to know is this:
If I make the X field in Table 2 a lookup of the B field in Table 1, how can I make the lookup return only the unique records in this field?
(I.e. The lookup in the X field of Table 2 would only show (2,1) and not (2,1,2).
 

Querys and Lookup fields

Querys and Lookup fields Icon
I have a table with multiple Lookup fields . I am trying the create an append query to copy data from this source table to another table.
From the fields that are lookups in the source, I end up with a number in that field in the target table, instead of text (I need text)
I've tried making that field in the target table a lookup field also, pointing to the same lookup table, but the query responds with an error about an INSERT INTO query cannot contain a multi-valued field. But I would really rather have text anyway.
How do I query text from a lookup field instead of the numerical value?
 

Use a lookup field to influence values in another field

Use a lookup field to influence values in another field Icon
I've been out of practise with using Access for a while,

Basically, I'm looking to create a table that holds event information. One of the fields I've successfully included is a Lookup function to pull info from a contacts table. This table also has statistics in it.

What I'd like to do on the events table is lookup a contact name in one field, and then in another field within the events table, pull over the relevant statistics based on my selection.

Now, I've been able to get the lookup to pull across of this already, but as far as I can tell, you're only able have one column displayed (bound) in the lookup - is this right?

If you've any suggestions I'
 

Insert Into vba help!

Insert Into vba help! Icon
I have a form tied to a table. One of the fields in the form is a lookup field full of choices from another table.

When the user clicks Save and Next I need to save the form and then update a 3rd table with many values from the form. The issue I'm having is the syntax error when trying to insertthe data from the lookup field into another table (whose same column is the exact same lookup)

What it is expecting is the ID from that lookup field's table. I tested this by placing a random number (e.g. 22) and it will place the text in the table for that value.
 

Is a Lookup Field the same thing as a lookup table

Is a Lookup Field the same thing as a lookup table Icon
From reading some of the threads, it's clear that Lookup Fields are not a good idea in tables.

I have found many resources online with examples of different databases and in one I am going through right now, there is one that has a People table (for both people and companies) and a Type table.

The Type table categorizes the type of relationship between the person/company in the People table and (presumably) the user/company keeping the database (relationships such as: Friend, Family, Professional, Auto, Hospital, Art Supply, etc).

**In the description for the Types table, there is a statement that says "The Types table is commonly referred to as a lookup table."**

My question is this: Is a Lookup Field the same thing as a lookup table, as described?
 

Add or change a lookup column

Add or change a lookup column Icon
Sometimes, the value you want is tracked in another table. For instance, suppose you want to record the customer for an order in the Orders table. However, all customer information is tracked in the Customers table. You can create a lookup column that displays the customer information in a combo box or list box control. Then, when you select the customer in that control, an appropriate - such as the customer's primary key value - is stored in the order record.
This article explains what a lookup column is and how to create one.
In this article
* What is a lookup column?
* Create a lookup column in Datasheet view
* Create a lookup column by using the Field List pane
* Create a lookup column in Design view
* Understanding the bound value and the display value in a lookup column
* Introducing the Lookup field properties
* Using the Lookup Wizard
* Change a lookup column
* Change a field to a lookup column
 

Access 2007: Creating a Lookup List

Access 2007: Creating a Lookup List Icon
Learn how to create a Lookup List to populate field data and to ensure consistency. This article shows you how to add lookup fields to a Microsoft Access table. First, it shows you how to use a wizard to add the lookup field, and then it shows you how to add the lookup field manually.
 

Add or change a lookup column that lets you store multiple values

Add or change a lookup column that lets you store multiple values Icon
Sometimes, the values you need are stored in another table. For instance, suppose you have an issue tracking database and you want to keep track of the employees and contractors to whom you have assigned an issue. Information about these people is tracked in the Contacts table. You can create a multivalued lookup column that displays names in a combo box or a list box control. When you select the people to whom you want to assign an issue, their contact ID values are stored in the issue record.
This article explains what a multivalued lookup column is and how to add one to a table. The article also explains how to convert an existing column to a multivalued lookup column.
In this article:
* What is a multivalued lookup column?
* Create a multivalued lookup column in Datasheet view
* Create a multivalued lookup column by using the Field List pane
* Create a multivalued lookup column in Design view
* Using the Lookup Wizard to create multivalued lookup columns
* Understanding the bound value and the display value in a multivalued lookup column
* Introducing the Lookup field properties
* Change the design of a lookup column for a multivalued field
 

Using a temporary field as a Lookup field

Using a temporary field as a Lookup field Icon
On the Lookup tab in Design View, I have set certain properties for the PersonID field in a PersonSocialNetwork table as follows:
...
The Person table has 3 fields: PersonID (Primary Key; Number data type), LastName, and FirstName.

The SELECT statement above is a modification of the one that the Lookup Wizard generated, and causes both the LastName and FirstName fields to be displayed as one temporary field, and (ideally) be associated with the PersonID.
 

simple address db question

simple address db question Icon
I know in the back of my mind I know how to do this but.

when I select the suburb in the lookup field I need the table to automatically update the postcode and state field from the lookup table - like a vlookup function in excel