473,898 Members | 2,185 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Lookup Field in a Table set to required

I have set up a table with a few fields that are set to
required....all work fine except the fields that are Lookup from
another table.

What am I forgetting to set?

Thanks!!
Mar 20 '08 #1
7 2598
On Wed, 19 Mar 2008 22:17:48 -0700 (PDT), samdev
<la***@noblesof twaresolutions. comwrote:

What you are forgetting is to tell us more about what is not working.

Presumably you are speaking about a form, and for the lookup fields
you have a dropdown that lists the values from the lookup table. So
far that is pretty standard. How does your implementation differ from
that?
You do have 2-column dropdowns, right? A hidden ID value and a visible
Description value. Several examples of this in the Northwind sample
application.

-Tom.
>I have set up a table with a few fields that are set to
required....al l work fine except the fields that are Lookup from
another table.

What am I forgetting to set?

Thanks!!
Mar 20 '08 #2
On Mar 20, 1:26*am, Tom van Stiphout <no.spam.tom7.. .@cox.netwrote:
On Wed, 19 Mar 2008 22:17:48 -0700 (PDT), samdev

<la...@noblesof twaresolutions. comwrote:

What you are forgetting is to tell us more about what is not working.

Presumably you are speaking about a form, and for the lookup fields
you have a dropdown that lists the values from the lookup table. So
far that is pretty standard. How does your implementation differ from
that?
You do have 2-column dropdowns, right? A hidden ID value and a visible
Description value. Several examples of this in the Northwind sample
application.

-Tom.
I have set up a table with a few fields that are set to
required....all work fine except the fields that are Lookup from
another table.
What am I forgetting to set?
Thanks!!- Hide quoted text -

- Show quoted text -
Sorry....

I have set the field to required at the Table level and yes it is drop-
down as you described and it allows me to input a complete record even
if I have left the lookup field blank. Other fields that I have set to
required, if I leave blank, Access will not allow me to complete/save
the record. I need all required fields to work properly - so not allow
a user to save the record unless all required fields are complete.

Thx,
Mar 20 '08 #3
On Wed, 19 Mar 2008 22:29:40 -0700 (PDT), samdev
<la***@noblesof twaresolutions. comwrote:

I don't think it quite works that way. You may need to double-check.
If a field does not allow nulls, it doesn't. It MAY accept an empty
string, but not null. Whether it is a lookup field or not has no
bearing on this.
Do you have a default value on this field?

-Tom.

>On Mar 20, 1:26*am, Tom van Stiphout <no.spam.tom7.. .@cox.netwrote:
>On Wed, 19 Mar 2008 22:17:48 -0700 (PDT), samdev

<la...@nobleso ftwaresolutions .comwrote:

What you are forgetting is to tell us more about what is not working.

Presumably you are speaking about a form, and for the lookup fields
you have a dropdown that lists the values from the lookup table. So
far that is pretty standard. How does your implementation differ from
that?
You do have 2-column dropdowns, right? A hidden ID value and a visible
Description value. Several examples of this in the Northwind sample
application.

-Tom.
>I have set up a table with a few fields that are set to
required....al l work fine except the fields that are Lookup from
another table.
>What am I forgetting to set?
>Thanks!!- Hide quoted text -

- Show quoted text -

Sorry....

I have set the field to required at the Table level and yes it is drop-
down as you described and it allows me to input a complete record even
if I have left the lookup field blank. Other fields that I have set to
required, if I leave blank, Access will not allow me to complete/save
the record. I need all required fields to work properly - so not allow
a user to save the record unless all required fields are complete.

Thx,
Mar 20 '08 #4

"samdev" <la***@noblesof twaresolutions. comwrote in message
news:44******** *************** ***********@13g 2000hsb.googleg roups.com...
>I have set up a table with a few fields that are set to
required....all work fine except the fields that are Lookup from
another table.

What am I forgetting to set?
If you truly mean they are defined as LookupFields in the Table, back slowly
away, making signs to ward off evil.

Replace the LookupFields with a Foreign Key to the Table where key and value
for the Lookup is stored. Now, if you insist on playing novice user and
looking at the datasheet view, you'll see the foreign key value, not the
descriptive information (but you'll be seeing exactly what is stored) and
you'll know you can create a query joining the two tables to see the full
information.

What you won't get are the "varagies and eccentricities" of Lookup Fields
which store one value and display another... for anyone who's not doing a
novice-level database and needs to flatten their files in the tables, Lookup
Fields end up being more trouble than they are worth, and should be replaced
with Lookup Tables, as I described above..

Larry Linson
Microsoft Office Access MVP
Mar 20 '08 #5
Be sure to heed Larry's advice. It will save you headaches and
bottles and bottles of asprin.
Mar 20 '08 #6
On Mar 20, 3:58*pm, "Larry Linson" <boun...@localh ost.notwrote:
"samdev" <la...@noblesof twaresolutions. comwrote in message

news:44******** *************** ***********@13g 2000hsb.googleg roups.com...
I have set up a table with a fewfieldsthat are set to
required....all work fine except thefieldsthat are Lookup from
another table.
What am I forgetting to set?

If you truly mean they are defined as LookupFields in the Table, back slowly
away, making signs to ward off evil.

Replace the LookupFields with a Foreign Key to the Table where key and value
for the Lookup is stored. Now, if you insist on playing novice user and
looking at the datasheet view, you'll see the foreign key value, not the
descriptive information (but you'll be seeing exactly what is stored) and
you'll know you can create a query joining the two tables to see the full
information.

What you won't get are the "varagies and eccentricities" of LookupFields
which store one value and display another... for anyone who's not doing a
novice-level database and needs to flatten their files in the tables, LookupFieldsend up being more trouble than they are worth, and should be replaced
with Lookup Tables, as I described above..

*Larry Linson
*Microsoft Office Access MVP
Thanks - sorry for all the confusion - I am using lookup tables! I'm
still having some issues but most I have worked out.
Mar 20 '08 #7
The question is not the use of lookup tables, but rather using the
lookup tables option in the actual table as opposed to using a lookup
query/table for a dropdown on a form.
Mar 20 '08 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
7040
by: Koen | last post by:
Hi all, My application uses a lot of lookup tables. I've splitted the frontend (forms, reports, etc) from the backend (data). The database has around 10 different users. The values in the lookup tables are not likely to change. Question 1: Should I include them in the backend (with rest of data) or the frontend?
3
2935
by: my-wings | last post by:
I've been reading about how evil Lookup fields in tables are, but I've got to be missing something really basic. I know this subject has been covered before, because I've just spent an hour or two reading about it on google, but there is something I still don't understand, and I'm hoping someone will be willing to explain it to me in small words. Let's say I have a table for addresses, and it includes a field for state. What I would...
1
3380
by: Zachary Turner | last post by:
I want to make a Lookup Field based on another Lookup field. In other words, I have this table A with two fields: ID and Name, where ID is an Autonumber and Name is a friendly name. Then I have a table B which links to A via a Lookup Field so that I can select the friendly name from combo box. Now, I want to have a table C which links to table B via a lookup field, and only displays the items which are selected in some combo box of some...
3
10690
by: google | last post by:
I have a database with four table. In one of the tables, I use about five lookup fields to get populate their dropdown list. I have read that lookup fields are really bad and may cause problems that are hard to find. The main problem I am having right now is that I have a report that is sorted by one of these lookup fields and it only displays the record's ID number. When I add the source table to the query it makes several records...
1
2142
by: Dan | last post by:
I am using an expression in Forms to take several fields of data and convert them to a block of text. For one of the fields set-up as a combo box, it is based on a Lookup of a separate table to text in a specified field. The table of data that is looked up has 3 fields: Index , Eng , Fr . When I concatenate the fields into the expression, the field for looking up the month displays as the numeric value of the lookup table, not the...
1
1909
by: Paul H | last post by:
Say I have a table called tblPeopleInfo, one of the fields in the table is called FavouriteFruit. The FavouriteFruit field is a lookup field and will contain Apples, Oranges, Grapes etc..The list can be added to by users of the database. What is the best way to construct this lookup? Should it lookup a Table/Query or a Value List? If it looks up to a Table/Query should the lookup table just have a single "text" field or should it have...
3
3556
by: Jimmy | last post by:
I'm not sure the subject line is a very clear description of my problem so... I have two relevant tables for this issue... the lookup table tblLookupItems with three fields . The control source for my form tblExpenses. In this table there are three relevant fields . On the form the field is set up as a combobox to get
11
2665
by: Paul H | last post by:
Suppose I have a table called tblPeople and I want a field to illustrate whether each person prefers cats or dogs. I could do it one of three ways. 1. A plain text field Create a text field in tblPeople called PreferredPet. 2. A lookup field that stores text values. Create a text field in tblPeople called PreferredPetID and use it to lookup an identical text field in tblPreferredPets.
6
5193
by: David Wright | last post by:
Hello Folks I am using Microsoft Access 2000 I would be grateful if someone could help me with “Dlookup”. I tried various methods of writing Dlookup and various events to trigger it, none of which were successful. I have been able to display the required value in a ‘text box’ which is a little helpful but not ideal. I have a table called tblLogSheet. The ‘Description’ field of this table uses a lookup table called...
0
10859
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10954
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10487
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9662
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
7191
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5882
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6078
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4708
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4297
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.