by: David Allison |
last post by:
Should Lookup fields be replaced by table normalisation? Then the Tables
brought together in a Query for a Form to be based on?
--
Dave Allison ~ Scotland
|
by: John Baker |
last post by:
Hi:
I have a general question about table access and look ups.
Over simplifying things,and using a very theoretical example, lets say I have two tables;
Client and Bill.
The client table...
|
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...
|
by: John Smith |
last post by:
I am trying to combine two lookup fields into one field for display on a
form and a report. I understand the basics behind how to do this:
I set the control source for a new text box control to...
|
by: Tim Dunne |
last post by:
What is the problem with these? I have never run into an issue with
them yet I hear time and time again that they should never be used. In
the "Ten Commandments of Access" they are said to be the...
|
by: Paul Howarth |
last post by:
Because I'm a novice, I can't reconcile a Recommendation to always avoid using Lookup Fields in Tables, and the Requirement to use Lookup Fields for a Published Access database. (Sources pasted...
|
by: Daedalus |
last post by:
I'm trying to use relationships to link more than two tables.
Using referencial intrgerity I can connect two tables so that by clicking a small + I can open one inside the other for the various...
|
by: cjr123 |
last post by:
I want to have a button on a form to Duplicate a record. Not all of the fields would be duplicated. The code works until I use the fields that are Lookup Fields. I am not sure how to type the names...
|
by: feeeee |
last post by:
I have seen again and again that lookup fields are to be avoided in tables. My question is:
Are all types of lookup fields evil?
I have avoided lookup fields that pull data from other tables.
...
|
by: cmo187265 |
last post by:
Intro:
I have been working on a Sports Card database and have many questions posted on this forum related to creating the database through MS Access. After some time (2 yrs) I have decided to...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
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...
|
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)...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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...
|
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...
|