I am trying to learn how to develop using Access to front end a MS SQL
back database. I am new to this so please bear with me.
1. I have a lookup table for Saluation, where I hv an ID which for each
salution type and a cloumn to store the Salutation itself for example
1 Mr
2 Mrs
etc
2 In my person table I store the Salutation ID ie 1 or 2 etc.
How do I ensure that when users update using a Lookup, only 1 or 2 for
example is passed into the person table?
2. I have subforms linked by IDs, how do I ensure when user create new
record via the subform, the ID is inherited ?
Thanks in advance 8 1402
this is a joke, right?
use the combobox wizard for #1. Set limit to list=true. also, don't
bother with lookups. They're a nightmare. If you don't believe me,
try creating queries with them.
2. how about enforcing referential integrity between the tables?
Time to get the manual out, I think.
Thanks for the response. I'm glad its easy for you. I'm completely new
to programming on RDMS, I really appreciate the pointers pi********@hotmail.com wrote: don't bother with lookups. They're a nightmare. If you don't believe me, try creating queries with them.
But, lookup tables are a fundamental concept in relational database
design, ie, many to many entity relationships, so I don't understand
this remark. Mind you, the OP is using the term "look up" in the wrong
context here, though his approach is correct, albeit depending on one's
point of view, possibly overkill for salutations. Is that where you're
coming from?
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto
"Tim Marshall" <TI****@PurplePandaChasers.Moertherium> wrote in message
news:do**********@coranto.ucs.mun.ca... pi********@hotmail.com wrote:
don't bother with lookups. They're a nightmare. If you don't believe me, try creating queries with them.
But, lookup tables are a fundamental concept in relational database design, ie, many to many entity relationships, so I don't understand this remark. Mind you, the OP is using the term "look up" in the wrong context here, though his approach is correct, albeit depending on one's point of view, possibly overkill for salutations. Is that where you're coming from?
Lookup _Tables_ are fine. It's the abominable Lookup Fields that The Boys
and Girls In Redmond, in their wisdom, inflicted upon poor Access
developers, that he is cautioning against.
Larry Linson
Microsoft Access MVP
Hi everyone thanks for the responses. My lookup tables for used for
more than just salutation but I thought it was a simple enough idea
that I can extrapolate the concept.
I also need to know how this could be done for example as I need to
pass a foreign key to another table for example, I have table with
schools information. When create a new record for teachers, they
obviously need to select a school which the teacher belong to but I
also update the correspoding teacher's record with the school ID.
Does this make sense?
Regards
Effendi Baba
Larry Linson wrote: Lookup _Tables_ are fine. It's the abominable Lookup Fields that The Boys and Girls In Redmond, in their wisdom, inflicted upon poor Access developers, that he is cautioning against.
Ahhh, I see what you're talking about. Sorry, Piet! 8)
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto
Larry & Tim,
I was thinking about that hideous lookup wizard thing. Not the join
table that splits a many-to-many relationship. The m-m tables are
absolutely necessary. That wizard thing causes more problems than it
solves, in my experience. That's what I meant.
Thanks everyone for the responses, I managed to find a solution by
creating a Combo box bound to the ID fields. Now, I'm off trying to
figure out other things :)
Regards This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: lester |
last post by:
a pre-beginner's question:
what is the pros and cons of .net, compared to ++
I am wondering what can I get if I continue to learn C# after I have learned
C --> C++ --> C# ??
I think there...
|
by: chris suckling |
last post by:
Hi, Im a newbie who has recently started looking at using ACCESS as a means
to creating Databases for work etc.
I have noticed that within the program there are options to use Visual Basic...
|
by: ljubo lecic via AccessMonster.com |
last post by:
I am an experienced ORACLE software developer who
met ACCESS few months ago and I must say that ,so far,
I am delighted. I rapidly developed a few aplications
and everything is working extremly...
|
by: jimscott77 |
last post by:
Can someone help with the following problem?
Original Question:
TextBox1 is bound to a dataset and at runtime shows a value of "5"
I am trying to use that value as follows:
TextBoxA.Text =...
|
by: Yoram Biberman |
last post by:
I have a few questions concerning concurrency control. I shall thank whoever
can help me.
Question #1
=========
Assume the following (concurrent) schedule, in which both transactions run
in a...
|
by: me |
last post by:
Hi All,
I am new to Classes and learniing the ropes with VB.NET express
Here's my question - say I have a want to manage a list of books.
Each book has an Author, Title and ISBN
Now, I am...
|
by: Roman Zeilinger |
last post by:
Hi
I have a beginner question concerning fscanf.
First I had a text file which just contained some
hex numbers:
0C100012
0C100012
....
|
by: a |
last post by:
Dear all vb.net developer
I want to know the time I need to master vb.net?
I'm beginner
|
by: Daniel |
last post by:
Looking for a good resource for beginners? books, online anything that will
get me started..
what im trying to focus on is building a small program in c# to look thru a
few files in a folder...
|
by: ddg_linux |
last post by:
I have been reading about and doing a lot of php code examples from
books but now I find myself wanting to do something practical with
some of the skills that I have learned.
I am a beginner php...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
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...
| |