473,322 Members | 1,734 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Looking for alternative to Look-up tables fields.

As a personal exercise, I'm trying to create a call tracking DB for
my own use at work.

Here's an abbreviated version of the database layout:

Company:
CompanyID - Primary Key (Text Length 4)
CompanyName
OtherData

Contacts:
CompanyID - Part 1 of Primary Key, is also a foreign key
ContactID - Part 2 of Primary Key (AutoNumber)
ContactName
OtherData

Incident:
CompanyID - Part 1 of Primary Key, is also foreign Key
IncidentID - Part 2 of Primary Key (AutoNumber)
ContactID - Foreign Key
OtherData

All of the obvious relations have been defined.

I'm looking for a way to simplify data entry into the Incident table.

I can easily make Incident.CompanyName a look-up table using the wizard.
That way I can select from a list of CompanyName(s) and get the
CompanyID entered into the Incident record.

In order to enter Incident.ContactID, I'd like to be able to select
from a drop-down list of ContactName such that all the ContactName(s)
"belong" to the Incident.CompanyID entered for that record.

I've spent the best part of 3 hours trying to fool the wizard into
doing what I want without sucess. I've even tried to manipulate
the SQL underlying the look-up field without sucess.

I realize that look-up fields are frowned upon for very good
reasons.

If someone can point me in the direction of a solution to my
Incident.ContactID
look-up problem or a different approach (without look-up fields)
I'd *really* appreciate it.

Using Access 2002 and I'm 1/2 way thru my first class in Access.
I've taken 2 classes in VB so I'm familiar (somewhat) with how to
program in VB/VBA.

adTHANKSvance!

Simeon

Nov 12 '05 #1
1 3413
"Simeon Nevel" <sn****@sonic.net> wrote in message
news:Xy********************@typhoon.sonic.net...
As a personal exercise, I'm trying to create a call tracking DB for
my own use at work.

Here's an abbreviated version of the database layout:

Company:
CompanyID - Primary Key (Text Length 4)
CompanyName
OtherData

Contacts:
CompanyID - Part 1 of Primary Key, is also a foreign key
ContactID - Part 2 of Primary Key (AutoNumber)
ContactName
OtherData

Incident:
CompanyID - Part 1 of Primary Key, is also foreign Key
IncidentID - Part 2 of Primary Key (AutoNumber)
ContactID - Foreign Key
OtherData

All of the obvious relations have been defined.

I'm looking for a way to simplify data entry into the Incident table.


Here is where you have gone wrong. One should never use tables for data
entry so simplifying this is never an issue. All interfaces to the data
should be with Forms and Reports. Tables are for structure only. Once you
move to doing your data entry with a form then all of these issues you have
go away. You can then use ComboBoxes on your forms to provide the lookup
functionality.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #2

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

Similar topics

5
by: Aaron Ginn | last post by:
I'm investigating the feasibility of using Python instead of Visual Basic for a commercial software package that I'm planning on developing. Now I'm absolutely a Python zealot. I use it for most...
0
by: EightNineThree | last post by:
I'm looking for examples for presenting text transcripts as an alternative to movies. TIA for ideas, pointers, and tutes. -- Karl Core Charles Sweeney says my sig is fine as it is.
2
by: Nobody | last post by:
Hi All, In my application I have the following implementation for ClassA and ClassC invoking a call on ClassB. void ClassA::DoSomething() { int value = m_pClassB->Read(enum1); }
62
by: christopher diggins | last post by:
Since nobody responded to my earlier post , I thought I would try to explain what I am doing a bit differently. When multiply inheriting pure virtual (abstract) base classes, a class obviously...
115
by: TheAd | last post by:
At this moment I use MsAccess and i can build about every databound application i want. Who knows about a serious open source alternative? Because Windows will be a client platform for some time, i...
2
by: Steph. | last post by:
Hi, Is there a .NET alternative to the LockWindowUpdate from Windows's user32 dLL ? Or is the only way to get this kind of function to import it from the DLL and by this way making the .NET...
2
by: Lord Brett Sinclair | last post by:
Hello everybody I was looking into installing the IEWebControls. Unfortunately, I have .Net Framework 1.1 Version 1.1.4322 with a MS dev Env. of 7.1.3088 It appears that the IEWebControls are...
4
by: Bob | last post by:
I know this is a tall order, but I'm looking for a book that talks about the implications of alternative approaches to languages than we typically see, such as allowing multiple inheritance......
6
by: Smithers | last post by:
Just looking to compile a list of "all the ways to implement events". I'm NOT looking to get into the merits or mechanics of each in this thread... just want to identify them all - good, bad, and...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.