|
|
Separate PK in Jxn Tbl? by
Neil
Whenever I've created junction tables in the past, I always made the PK of
the junction table the combined pks from the two other tables. Ex: Table1
PK=A;...
( 1 2 3 ... Last Page)
|
|
222 |
8,802 |
|
|
|
|
73 |
2,724 |
|
|
|
|
60 |
2,393 |
|
|
Autonumber Fields by
Denis
Access allows a table to have an autonumber field which could be considered a
record number.
In an application I am involved in developing there are a number...
( 1 2 3 ... Last Page)
|
September 29th, 2005 02:14 PM
by BruceM
|
59 |
2,389 |
|
|
How do you mulitply in a field? by
wazabbbi
I created a table with two fields named "projectestimate" and "inspectionfee".
The inspection fee is 5% of the project estimate. I want the "inspectionfee"...
( 1 2 3 ... Last Page)
|
|
56 |
2,291 |
|
|
Table/Forms Design Question by
Damian
I am Trying to create Daily Reports for my company.
I created tables for Carpenters, Laborers, Surveyors, Ironworkers etc.
Each of these has fields *_Name,...
( 1 2 3 ... Last Page)
|
July 29th, 2009 06:43 PM
by Damian
|
54 |
3,272 |
|
|
|
|
51 |
3,439 |
|
|
|
|
47 |
1,796 |
|
|
|
|
40 |
2,019 |
|
|
|
|
40 |
1,710 |
|
|
|
|
38 |
1,874 |
|
|
|
August 14th, 2006 09:06 PM
by Bob
|
37 |
1,786 |
|
|
Hostel Database Setup by
andreainpanama
Thanks to all of you for all of your help.
I have a small backpackers hostel and I am currently working on a database
to help me keep track of all of my...
( 1 2 3 ... Last Page)
|
|
36 |
1,627 |
|
|
invoice number by
cjgav
I would like to add an invoice number to report which is generated only when
the invoice is printed can anyone explain how to do this please
( 1 2 3 ... Last Page)
|
June 17th, 2009 10:01 PM
by cjgav
|
36 |
1,964 |
|
|
A2007 - OLE vs. Attachements by
Jay Oken
I would like to add a picture to a record but do not know the best way to do
it. From what I can see OLE gives the option to "link" to the picture file...
( 1 2 3 ... Last Page)
|
November 20th, 2009 10:28 PM
by johnlute
|
36 |
2,174 |
|
|
|
|
35 |
1,851 |
|
|
|
|
34 |
2,644 |
|
|
do I need more indexes? by
jmoore[_2_]
After reading several posts here I have changed all of the lookup fields to
text fields in my table and deleted the relationships to the lookup tables.
I...
( 1 2 3 ... Last Page)
|
|
33 |
2,090 |
|
|
Membership database updates by
Pennington
I have created a membership database for our local branch of a charity and
designed various queries and reports to analyze particular trends. The source...
( 1 2 3 ... Last Page)
|
|
33 |
1,881 |
|
|
Monthly Vendor Report by
DRoads
Need help and don't know where to start. Working in Access 2007 and need to
create the following.......
Need to create the following report
V# Vendor...
( 1 2 3 ... Last Page)
|
|
30 |
2,328 |