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: David |
last post by:
Would someone please explain how I can activate the pull down lookup fields
in a db grid.
I have created a SQL database within ACCESS and converted to SQL using the
upsize wizard.
The...
|
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: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
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: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
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: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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,...
|