I have searched high and low for a sample for this, and I just can't
find any. Sorry for the length!
Background Information
The issue revolves around setting up a system-generated increase in
two of a three-part field - one numeric the other text. The Org
Number, Incremental Number, and Subcontractor Designation make up the
Audit Identification number(7) for queries and reports. There is a
hyphen between Org Number and Incremental Number. I've had to number
the columns as I can't fit the names on them - sorry.
1. Autonumbering showing repeated sequences
1 - Audits Table - PK=tblAuditsID - covers 1, 2 and 3 Is 1:M
tblContractor
2. Org Number field (text) This is chosen from a combo box from a
lookup table, there are 27 different Org Numbers
3. Incremental Number field (numeric)
4. Contractor Name field
Contractor Table PK=tblContracto rID, FK is tblAudit IDTable
5. SubContractor Designation field
SubContractor Table - PK=tblSubcontra ctorID, FK=tblContracto rID -
covers 5 & 6
6. SubContractor Name
7. Audit Identification Number - Final needed results
1 2 3 4 5 6 7
1 P1100 100 OASIS Co P1100-0100
2 P1200 2173 XYZ Co P1200-2173
3 P1300 569 123 Co
P1300-0569
3 A 56 Co
P1300-0569A
4 P1400 1952 WEX Co P1400-1952
4 A KELP Co.
P1400-1952A
5 P1500 2173 ABC Co P1500-2173
5 A DEF Co.
P1500-2173A
5 B Peter Paul
P1500-2173B
5 C Mary Smith
P1500-2173C
6 P1550 59 Boxer
P1550-0059
7 P1600 961 Davis Max P1600-0961
8 P1700 1 Charlie's
P1700-0001
9 P1800 5 Mary Lamb P1800-0005
10 P1900 590 Nemo P1900-0950
11 P2000 232 Harry
P2000-0232
Numeric Autonumber
The value in the Increment field (third column) represents the last
number used in the old system. In the new database it would have to
start at the last number shown in that field plus an increment of one
for each of the Org Numbers (2),in which there is a new assignment.
The user would also have to have the ability to:
* Open up an existing record and be able to add additional
subcontractors and/or amendments that reside in other tables.
* Be able to pull up an exiting record to add additional information
from another input form.
The last four fields (4-7) in the table above are in different tables
and are shown here for illustration purposes. I repeated the Primary
Key Autonumber (1) to show you when we are on the same record. The
real database would not have the primary key repeated.
Text Autonumber
When the user gets to the part of the record to enter the
SubContractor names (6)in the Subcontractor Table (6) he/she will use
a combo box to add those subcontractors who are working for a
particular prime contractor (4) into the SubContractor Name (6)
field. The contract identifies all the applicable subcontractors.
After the first subcontractor is added to the Subcontractor Table, a
value of A-ZZ (5) needs to be placed in the SubDesignation (5) field
in the Subcontractor Table. (5) It represents the designation for
that subcontractor. As each additional subcontractor is added in the
SubContractor Name field the system needs to use the next available
letter up to and including ZZ if there are that many subcontractors
included in the contract.
Clear as mud? From the Audit table, I need to choose the Org number
(P1100), add a dash, add the Incremental number (4 byte, so leading
zero's) to it plus 1, and if there is a subcontractor add an A (A-ZZ),
another subcontractor add a B & so on.
Thank you for even reading this. If my chart didn't come in clearly
and you are interested in helping, let me know and I'll send you
another one. I am just not a programmer and really need help with
this. All of the tables have been normalized, and if you need to see
the data model just let me know. Thank You.
Elfae
8  1840 
On Dec 12, 11:13 pm, Elfae <nanc...@efn.or gwrote:
I have searched high and low for a sample for this, and I just can't
find any. Sorry for the length!
Background Information
The issue revolves around setting up a system-generated increase in
two of a three-part field - one numeric the other text. The Org
Number, Incremental Number, and Subcontractor Designation make up the
Audit Identification number(7) for queries and reports. There is a
hyphen between Org Number and Incremental Number. I've had to number
the columns as I can't fit the names on them - sorry.
1. Autonumbering showing repeated sequences
1 - Audits Table - PK=tblAuditsID - covers 1, 2 and 3 Is 1:M
tblContractor
2. Org Number field (text) This is chosen from a combo box from a
lookup table, there are 27 different Org Numbers
3. Incremental Number field (numeric)
4. Contractor Name field
Contractor Table PK=tblContracto rID, FK is tblAudit IDTable
5. SubContractor Designation field
SubContractor Table - PK=tblSubcontra ctorID, FK=tblContracto rID -
covers 5 & 6
6. SubContractor Name
7. Audit Identification Number - Final needed results
1 2 3 4 5 6 7
1 P1100 100 OASIS Co P1100-0100
2 P1200 2173 XYZ Co P1200-2173
3 P1300 569 123 Co P1300-0569
3 A 56 Co P1300-0569A
4 P1400 1952 WEX Co P1400-1952
4 A KELP Co. P1400-1952A
5 P1500 2173 ABC Co P1500-2173
5 A DEF Co. P1500-2173A
5 B Peter Paul P1500-2173B
5 C Mary Smith P1500-2173C
6 P1550 59 Boxer P1550-0059
7 P1600 961 Davis Max P1600-0961
8 P1700 1 Charlie's P1700-0001
9 P1800 5 Mary Lamb P1800-0005
10 P1900 590 Nemo P1900-0950
11 P2000 232 Harry P2000-0232
Numeric Autonumber
The value in the Increment field (third column) represents the last
number used in the old system. In the new database it would have to
start at the last number shown in that field plus an increment of one
for each of the Org Numbers (2),in which there is a new assignment.
The user would also have to have the ability to:
* Open up an existing record and be able to add additional
subcontractors and/or amendments that reside in other tables.
* Be able to pull up an exiting record to add additional information
from another input form.
The last four fields (4-7) in the table above are in different tables
and are shown here for illustration purposes. I repeated the Primary
Key Autonumber (1) to show you when we are on the same record. The
real database would not have the primary key repeated.
Text Autonumber
When the user gets to the part of the record to enter the
SubContractor names (6)in the Subcontractor Table (6) he/she will use
a combo box to add those subcontractors who are working for a
particular prime contractor (4) into the SubContractor Name (6)
field. The contract identifies all the applicable subcontractors.
After the first subcontractor is added to the Subcontractor Table, a
value of A-ZZ (5) needs to be placed in the SubDesignation (5) field
in the Subcontractor Table. (5) It represents the designation for
that subcontractor. As each additional subcontractor is added in the
SubContractor Name field the system needs to use the next available
letter up to and including ZZ if there are that many subcontractors
included in the contract.
Clear as mud? From the Audit table, I need to choose the Org number
(P1100), add a dash, add the Incremental number (4 byte, so leading
zero's) to it plus 1, and if there is a subcontractor add an A (A-ZZ),
another subcontractor add a B & so on.
Thank you for even reading this. If my chart didn't come in clearly
and you are interested in helping, let me know and I'll send you
another one. I am just not a programmer and really need help with
this. All of the tables have been normalized, and if you need to see
the data model just let me know. Thank You.
Elfae
I corrected the chart. Elfae
On Dec 12, 11:13 pm, Elfae <nanc...@efn.or gwrote:
I have searched high and low for a sample for this, and I just can't
find any. Sorry for the length!
Background Information
The issue revolves around setting up a system-generated increase in
two of a three-part field - one numeric the other text. The Org
Number, Incremental Number, and Subcontractor Designation make up the
Audit Identification number(7) for queries and reports. There is a
hyphen between Org Number and Incremental Number. I've had to number
the columns as I can't fit the names on them - sorry.
1. Autonumbering showing repeated sequences
1 - Audits Table - PK=tblAuditsID - covers 1, 2 and 3 Is 1:M
tblContractor
2. Org Number field (text) This is chosen from a combo box from a
lookup table, there are 27 different Org Numbers
3. Incremental Number field (numeric)
4. Contractor Name field
Contractor Table PK=tblContracto rID, FK is tblAudit IDTable
5. SubContractor Designation field
SubContractor Table - PK=tblSubcontra ctorID, FK=tblContracto rID -
covers 5 & 6
6. SubContractor Name
7. Audit Identification Number - Final needed results
1 2 3 4 5 6 7
1 P1100 100 OASIS Co P1100-0100
2 P1200 2173 XYZ Co P1200-2173
3 P1300 569 123 Co P1300-0569
3 A 56 Co P1300-0569A
4 P1400 1952 WEX Co P1400-1952
4 A KELP Co.P1400-1952A
5 P1500 2173 ABC Co P1500-2173
5 A DEF Co. P1500-2173A
5 B Peter Paul P1500-2173B
5 C Mary Smith P1500-2173C
6 P1550 59 Boxer P1550-0059
7 P1600 961 Davis Max P1600-0961
8 P1700 1 Charlie's P1700-0001
9 P1800 5 Mary Lamb P1800-0005
10 P1900 590 Nemo P1900-0950
11 P2000 232 Harry P2000-0232
Numeric Autonumber
The value in the Increment field (third column) represents the last
number used in the old system. In the new database it would have to
start at the last number shown in that field plus an increment of one
for each of the Org Numbers (2),in which there is a new assignment.
The user would also have to have the ability to:
* Open up an existing record and be able to add additional
subcontractors and/or amendments that reside in other tables.
* Be able to pull up an exiting record to add additional information
from another input form.
The last four fields (4-7) in the table above are in different tables
and are shown here for illustration purposes. I repeated the Primary
Key Autonumber (1) to show you when we are on the same record. The
real database would not have the primary key repeated.
Text Autonumber
When the user gets to the part of the record to enter the
SubContractor names (6)in the Subcontractor Table (6) he/she will use
a combo box to add those subcontractors who are working for a
particular prime contractor (4) into the SubContractor Name (6)
field. The contract identifies all the applicable subcontractors.
After the first subcontractor is added to the Subcontractor Table, a
value of A-ZZ (5) needs to be placed in the SubDesignation (5) field
in the Subcontractor Table. (5) It represents the designation for
that subcontractor. As each additional subcontractor is added in the
SubContractor Name field the system needs to use the next available
letter up to and including ZZ if there are that many subcontractors
included in the contract.
Clear as mud? From the Audit table, I need to choose the Org number
(P1100), add a dash, add the Incremental number (4 byte, so leading
zero's) to it plus 1, and if there is a subcontractor add an A (A-ZZ),
another subcontractor add a B & so on.
Thank you for even reading this. If my chart didn't come in clearly
and you are interested in helping, let me know and I'll send you
another one. I am just not a programmer and really need help with
this. All of the tables have been normalized, and if you need to see
the data model just let me know. Thank You.
Elfae
Elfae <na*****@efn.or gwrote in news:dc34b98b-d20e-45b9-89c7- a8**********@d2 1g2000prf.googl egroups.com:
I have searched high and low for a sample for this, and I just can't
find any. Sorry for the length!
Background Information
The issue revolves around setting up a system-generated increase in
two of a three-part field - one numeric the other text. The Org
Number, Incremental Number, and Subcontractor Designation make up the
Audit Identification number(7) for queries and reports. There is a
hyphen between Org Number and Incremental Number. I've had to number
the columns as I can't fit the names on them - sorry.
1. Autonumbering showing repeated sequences
1 - Audits Table - PK=tblAuditsID - covers 1, 2 and 3 Is 1:M
tblContractor
2. Org Number field (text) This is chosen from a combo box from a
lookup table, there are 27 different Org Numbers
3. Incremental Number field (numeric)
4. Contractor Name field
Contractor Table PK=tblContracto rID, FK is tblAudit IDTable
5. SubContractor Designation field
SubContractor Table - PK=tblSubcontra ctorID, FK=tblContracto rID -
covers 5 & 6
6. SubContractor Name
7. Audit Identification Number - Final needed results
1 2 3 4 5 6 7
1 P1100 100 OASIS Co P1100-0100
2 P1200 2173 XYZ Co P1200-2173
3 P1300 569 123 Co
P1300-0569
3 A 56 Co
P1300-0569A
4 P1400 1952 WEX Co P1400-1952
4 A KELP Co.
P1400-1952A
5 P1500 2173 ABC Co P1500-2173
5 A DEF Co.
P1500-2173A
5 B Peter Paul
P1500-2173B
5 C Mary Smith
P1500-2173C
6 P1550 59 Boxer
P1550-0059
7 P1600 961 Davis Max P1600-0961
8 P1700 1 Charlie's
P1700-0001
9 P1800 5 Mary Lamb P1800-0005
10 P1900 590 Nemo P1900-0950
11 P2000 232 Harry
P2000-0232
Numeric Autonumber
The value in the Increment field (third column) represents the last
number used in the old system. In the new database it would have to
start at the last number shown in that field plus an increment of one
for each of the Org Numbers (2),in which there is a new assignment.
The user would also have to have the ability to:
* Open up an existing record and be able to add additional
subcontractors and/or amendments that reside in other tables.
* Be able to pull up an exiting record to add additional information
from another input form.
The last four fields (4-7) in the table above are in different tables
and are shown here for illustration purposes. I repeated the Primary
Key Autonumber (1) to show you when we are on the same record. The
real database would not have the primary key repeated.
Text Autonumber
When the user gets to the part of the record to enter the
SubContractor names (6)in the Subcontractor Table (6) he/she will use
a combo box to add those subcontractors who are working for a
particular prime contractor (4) into the SubContractor Name (6)
field. The contract identifies all the applicable subcontractors.
After the first subcontractor is added to the Subcontractor Table, a
value of A-ZZ (5) needs to be placed in the SubDesignation (5) field
in the Subcontractor Table. (5) It represents the designation for
that subcontractor. As each additional subcontractor is added in the
SubContractor Name field the system needs to use the next available
letter up to and including ZZ if there are that many subcontractors
included in the contract.
Clear as mud? From the Audit table, I need to choose the Org number
(P1100), add a dash, add the Incremental number (4 byte, so leading
zero's) to it plus 1, and if there is a subcontractor add an A (A-ZZ),
another subcontractor add a B & so on.
Thank you for even reading this. If my chart didn't come in clearly
and you are interested in helping, let me know and I'll send you
another one. I am just not a programmer and really need help with
this. All of the tables have been normalized, and if you need to see
the data model just let me know. Thank You.
Elfae
But what's your question?
Column Seven? It contains informtation from three other columns. It's
redundant and most developers would remove it (not create it in the
first place). It is always available as
[Column2] & "-" & Format([Column3], "0000") & [Column5]
(using the real names for the columns).
A - ZZ for the subcontractors? We could invent some wonderfuly clever
procedure for assigning these designations. But we have a max of 52
subcontractors? Then it shouldn't be inefficient to have the
subcontractors and their designations stored in a separate table and its
data, including the A-ZZ designation to be entered interactively. It
would, of course, be the basis for the listbox you mention.
You've said you are not a programmer. For people who are not programmers,
keeping things as simple as possible is a great idea. I think you
haven't.
Experienced programmers, of course, keep things simple as as habit.
Wannabe programmers display their long and complicated code. And they
remain wannabes.
--
lyle fairfield
On Dec 14, 5:09 am, lyle fairfield <lylef...@yahoo .cawrote:
Elfae <nanc...@efn.or gwrote in news:dc34b98b-d20e-45b9-89c7-
a8fabbe70...@d2 1g2000prf.googl egroups.com:
I have searched high and low for a sample for this, and I just can't
find any. Sorry for the length!
Background Information
The issue revolves around setting up asystem-generatedincrea se in
two of a three-part field - one numeric the other text. The Org
Number, IncrementalNumb er, and Subcontractor Designation make up the
Audit Identificationn umber(7) for queries and reports. There is a
hyphen between OrgNumberand IncrementalNumb er. I've had tonumber
the columns as I can't fit the names on them - sorry.
1. Autonumbering showing repeated sequences
1 - Audits Table - PK=tblAuditsID - covers 1, 2 and 3 Is 1:M
tblContractor
2. OrgNumberfield (text) This is chosen from a combo box from a
lookup table, there are 27 different Org Numbers
3. IncrementalNumb erfield (numeric)
4. Contractor Name field
Contractor Table PK=tblContracto rID, FK is tblAudit IDTable
5. SubContractor Designation field
SubContractor Table - PK=tblSubcontra ctorID, FK=tblContracto rID -
covers 5 & 6
6. SubContractor Name
7. Audit IdentificationN umber- Final needed results
1 2 3 4 5 6 7
1 P1100 100 OASIS Co P1100-0100
2 P1200 2173 XYZ Co P1200-2173
3 P1300 569 123 Co
P1300-0569
3 A 56 Co
P1300-0569A
4 P1400 1952 WEX Co P1400-1952
4 A KELP Co.
P1400-1952A
5 P1500 2173 ABC Co P1500-2173
5 A DEF Co.
P1500-2173A
5 B Peter Paul
P1500-2173B
5 C Mary Smith
P1500-2173C
6 P1550 59 Boxer
P1550-0059
7 P1600 961 Davis Max P1600-0961
8 P1700 1 Charlie's
P1700-0001
9 P1800 5 Mary Lamb P1800-0005
10 P1900 590 Nemo P1900-0950
11 P2000 232 Harry
P2000-0232
Numeric Autonumber
The value in the Increment field (third column) represents the last
numberused in the oldsystem. In the new database it would have to
start at the lastnumbershown in that field plus an increment of one
for each of the Org Numbers (2),in which there is a new assignment.
The user would also have to have the ability to:
* Open up anexistingrecor d and be able to add additional
subcontractors and/or amendments that reside in other tables.
* Be able to pull up an exiting record to add additional information
from another input form.
The last fourfields(4-7) in the table above are in different tables
and are shown here for illustration purposes. I repeated the Primary
Key Autonumber (1) to show you when we are on the same record. The
real database would not have the primary key repeated.
Text Autonumber
When the user gets to the part of the record to enter the
SubContractor names (6)in the Subcontractor Table (6) he/she will use
a combo box to add those subcontractors who are working for a
particular prime contractor (4) into the SubContractor Name (6)
field. The contract identifies all the applicable subcontractors.
After the first subcontractor is added to the Subcontractor Table, a
value of A-ZZ (5) needs to be placed in the SubDesignation (5) field
in the Subcontractor Table. (5) It represents the designation for
that subcontractor. As each additional subcontractor is added in the
SubContractor Name field thesystemneeds to use the next available
letter up to and including ZZ if there are that many subcontractors
included in the contract.
Clear as mud? From the Audit table, I need to choose the Orgnumber
(P1100), add a dash, add the Incrementalnumb er(4 byte, so leading
zero's) to it plus 1, and if there is a subcontractor add an A (A-ZZ),
another subcontractor add a B & so on.
Thank you for even reading this. If my chart didn't come in clearly
and you are interested in helping, let me know and I'll send you
another one. I am just not a programmer and really need help with
this. All of the tables have been normalized, and if you need to see
the data model just let me know. Thank You.
Elfae
But what's your question?
Column Seven? It contains informtation from three other columns. It's
redundant and most developers would remove it (not create it in the
first place). It is always available as
[Column2] & "-" & Format([Column3], "0000") & [Column5]
(using the real names for the columns).
A - ZZ for the subcontractors? We could invent some wonderfuly clever
procedure for assigning these designations. But we have a max of 52
subcontractors? Then it shouldn't be inefficient to have the
subcontractors and their designations stored in a separate table and its
data, including the A-ZZ designation to be entered interactively. It
would, of course, be the basis for the listbox you mention.
You've said you are not a programmer. For people who are not programmers,
keeping things as simple as possible is a great idea. I think you
haven't.
Experienced programmers, of course, keep things simple as as habit.
Wannabe programmers display their long and complicated code. And they
remain wannabes.
--
lyle fairfield
Well, aren't you just the person I needed to run me down. Nice going,
gosh, you should be quite proud of yourself. I am a very experienced
developer, I guess I should ask how many commercial systems you have?
But, I only have 7. I also see you don't comprehend what you read.
I'll state it again. The last four fields(4-7) in the table above
are in different tables and are shown here for illustration purposes
only.
My question? I'll that again also: From the Audit table, I need
to choose the Orgnumber
(P1100), add a dash, add the Incrementalnumb er(4 byte, so leading
zero's) to it plus 1, and if there is a subcontractor add an A (A-ZZ),
another subcontractor add a B & so on.
I said nothing about a listbox. And there are not only 52
subcontractors. Subcontractors are interchangeable with Contractors
and are in a lookup table.
Perhaps is you actually studied my question, you could give an answer
that actually becomes a programmer.
On Dec 14, 7:45 pm, Elfae <nanc...@efn.or gwrote:
On Dec 14, 5:09 am, lyle fairfield <lylef...@yahoo .cawrote:
Elfae <nanc...@efn.or gwrote in news:dc34b98b-d20e-45b9-89c7-
a8fabbe70...@d2 1g2000prf.googl egroups.com:
I have searched high and low for a sample for this, and I just can't
find any. Sorry for the length!
Background Information
The issue revolves around setting up asystem-generatedincrea se in
two of a three-part field - one numeric the other text. The Org
>Number, IncrementalNumb er, and Subcontractor Designation make up the
Audit Identificationn umber(7) for queries and reports. There is a
hyphen between OrgNumberand IncrementalNumb er. I've had tonumber
the columns as I can't fit the names on them - sorry.
1. Autonumbering showing repeated sequences
1 - Audits Table - PK=tblAuditsID - covers 1, 2 and 3 Is 1:M
tblContractor
2. OrgNumberfield (text) This is chosen from a combo box from a
lookup table, there are 27 different Org Numbers
3. IncrementalNumb erfield (numeric)
4. Contractor Name field
Contractor Table PK=tblContracto rID, FK is tblAudit IDTable
5. SubContractor Designation field
SubContractor Table - PK=tblSubcontra ctorID, FK=tblContracto rID -
covers 5 & 6
6. SubContractor Name
7. Audit IdentificationN umber- Final needed results
1 2 3 4 5 6 7
1 P1100 100 OASIS Co P1100-0100
2 P1200 2173 XYZ Co P1200-2173
3 P1300 569 123 Co
P1300-0569
3 A 56 Co
P1300-0569A
4 P1400 1952 WEX Co P1400-1952
4 A KELP Co.
P1400-1952A
5 P1500 2173 ABC Co P1500-2173
5 A DEF Co.
P1500-2173A
5 B Peter Paul
P1500-2173B
5 C Mary Smith
P1500-2173C
6 P1550 59 Boxer
P1550-0059
7 P1600 961 Davis Max P1600-0961
8 P1700 1 Charlie's
P1700-0001
9 P1800 5 Mary Lamb P1800-0005
10 P1900 590 Nemo P1900-0950
11 P2000 232 Harry
P2000-0232
Numeric Autonumber
The value in the Increment field (third column) represents the last
>numberused in the oldsystem. In the new database it would have to
start at the lastnumbershown in that field plus an increment of one
for each of the Org Numbers (2),in which there is a new assignment.
The user would also have to have the ability to:
* Open up anexistingrecor d and be able to add additional
subcontractors and/or amendments that reside in other tables.
* Be able to pull up an exiting record to add additional information
from another input form.
The last fourfields(4-7) in the table above are in different tables
and are shown here for illustration purposes. I repeated the Primary
Key Autonumber (1) to show you when we are on the same record. The
real database would not have the primary key repeated.
Text Autonumber
When the user gets to the part of the record to enter the
SubContractor names (6)in the Subcontractor Table (6) he/she will use
a combo box to add those subcontractors who are working for a
particular prime contractor (4) into the SubContractor Name (6)
field. The contract identifies all the applicable subcontractors.
After the first subcontractor is added to the Subcontractor Table, a
value of A-ZZ (5) needs to be placed in the SubDesignation (5) field
in the Subcontractor Table. (5) It represents the designation for
that subcontractor. As each additional subcontractor is added in the
SubContractor Name field thesystemneeds to use the next available
letter up to and including ZZ if there are that many subcontractors
included in the contract.
Clear as mud? From the Audit table, I need to choose the Orgnumber
(P1100), add a dash, add the Incrementalnumb er(4 byte, so leading
zero's) to it plus 1, and if there is a subcontractor add an A (A-ZZ),
another subcontractor add a B & so on.
Thank you for even reading this. If my chart didn't come in clearly
and you are interested in helping, let me know and I'll send you
another one. I am just not a programmer and really need help with
this. All of the tables have been normalized, and if you need to see
the data model just let me know. Thank You.
Elfae
But what's your question?
Column Seven? It contains informtation from three other columns. It's
redundant and most developers would remove it (not create it in the
first place). It is always available as
[Column2] & "-" & Format([Column3], "0000") & [Column5]
(using the real names for the columns).
A - ZZ for the subcontractors? We could invent some wonderfuly clever
procedure for assigning these designations. But we have a max of 52
subcontractors? Then it shouldn't be inefficient to have the
subcontractors and their designations stored in a separate table and its
data, including the A-ZZ designation to be entered interactively. It
would, of course, be the basis for the listbox you mention.
You've said you are not a programmer. For people who are not programmers,
keeping things as simple as possible is a great idea. I think you
haven't.
Experienced programmers, of course, keep things simple as as habit.
Wannabe programmers display their long and complicated code. And they
remain wannabes.
--
lyle fairfield
Well, aren't you just the person I needed to run me down. Nice going,
gosh, you should be quite proud of yourself. I am a very experienced
developer, I guess I should ask how many commercial systems you have?
But, I only have 7. I also see you don't comprehend what you read.
I'll state it again. The last four fields(4-7) in the table above
are in different tables and are shown here for illustration purposes
only.
My question? I'll that again also: From the Audit table, I need
to choose the Orgnumber
(P1100), add a dash, add the Incrementalnumb er(4 byte, so leading
zero's) to it plus 1, and if there is a subcontractor add an A (A-ZZ),
another subcontractor add a B & so on.
I said nothing about a listbox. And there are not only 52
subcontractors. Subcontractors are interchangeable with Contractors
and are in a lookup table.
Perhaps is you actually studied my question, you could give an answer
that actually becomes a programmer.
There are many kind people who post here regularly and I hope that one
or more of them will help you.
Elfae wrote:
Thank you for even reading this. If my chart didn't come in clearly
and you are interested in helping, let me know and I'll send you
another one. I am just not a programmer and really need help with
this. All of the tables have been normalized, and if you need to see
the data model just let me know. Thank You.
Post the data model. I think the help you need starts there.
lyle fairfield <ly******@yahoo .cawrote in
news:Uf******** ***********@rea d1.cgocable.net :
A - ZZ for the subcontractors? We could invent some wonderfuly
clever procedure for assigning these designations. But we have a
max of 52 subcontractors?
26 * 26 will give the total number of subcontractors. 52 is 26 + 26.
It's not too difficult to convert a number to a string of letters for
display, but it is a *royal* pain to convert a string into a number for
incrementing.
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from http://www.teranews.com
Elfae <na*****@efn.or gwrote in
news:1ffb3fa9-8215-4ff5-934b- 6d**********@a3 5g2000prf.googl egroups.co
m:
[egocentric rant snipped]
If you want to extend a helping hand, do so, if you don't, please
just don't answer at all.
I did extend a helping hand. Read what I said about how to handle
your incrementing string... store it as a number and just display it
as a string... You said you searched high and low and didn't find
anything, guess why. It's not worth the pain to do it the way you
originally envisaged.
>Your letter suffix is going to bite you eventually, you will be
better off to use a numeric suffix in your tables, there are many
code examples on how to programatically increment anumberon the
web and in books. You can also use a little function to convert
thenumberto a letter for display purposes, but, as Lyle said,
"Keep it simple"
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from http://www.teranews.com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Penn Markham |
last post by:
Hello all,
I am writing a script where I need to use the system() function to call
htpasswd. I can do this just fine on the command line...works great
(see attached file, test.php). When my webserver runs that part of the
script (see attached file, snippet.php), though, it doesn't go through.
I don't get an error message or anything...it just returns a "1"
(whereas it should return a "0") as far as I can tell. I have read the
PHP...
|
by: Paul Ponting |
last post by:
Hi
Is it possible to do basic file system access within HTML?
I want to be able to do the following tasks to a known full path and
filename
Delete (with warning prompt if possible)
Open
Open containing folder
Get the files properties
|
by: EmmettPower |
last post by:
Hi,
I have a form which includes a field 'number'. When 'number' is changed
additional fields ('item_0', etc) are generated on the form using
'onchange'.
I want to validate the form using Javascript before submission.
I've set out the part of the validation script used to loop through the
dynamically generated fields below. This is where I am encountering
|
by: Riley DeWiley |
last post by:
I have an application with two tables, A and B. Each has an autonumber
unique ID field, plus other data.
I have a junction table, AB, containing fields AID, BID, and Count (a
number).
AB has a combined unique key comprising AID and BID, that is, any
combination of the two must be unique, even though any given AID or BID may
exist in many records.
|
by: Tom |
last post by:
Hi,
I am currently looking for a Content Management System for one of my project
in ASP.NET.
Here are the requirements:
* web based content management
* ability to enter content/fragment in a structured way (mixture of plain
text input fields, drop-downs, radio buttons and rich text fields)
| | |
by: mattias192 |
last post by:
I cannot make sense of the ODBC error messages my VBA application
throws at me. I connect to an Access database of about 500MB in size.
First, there is the "Not enough space on temporary disk". This happens
when I insert many rows to my Access database. If I increase the ODBC
Buffer size from 2048kB to 8192kB the inserts seem to work fine.
When I try deleting the rows (still from my VBA application) it
complains about that...
|
by: forest demon |
last post by:
for example, let's say I do something like,
System.Diagnostics.Process.Start("notepad.exe","sample.txt");
if the user does a SaveAs (in notepad), how can i capture the path that
the user selects?
thanks...
|
by: Jimmy |
last post by:
Here's my issue. I'm using a calculated control to combine two fields on a
form & report. The two fields are RecordID (the autonumber primary key) and
a field named ProductCost. The idea is to create a "mysterious number" on
the forms & reports to hide the product cost so that customer looking at the
report wont know what it is. The catch, however, is that the salespeople
need to be able to quickly decipher the code. Ideally this would mean...
|
by: Iluvatar |
last post by:
Hi,
last week our project upgraded from vs.net 2005 to vs.net 2008. Our
project still uses framework 2.0, because the deployment servers are
not 3.x ready yet. Everything so far while migrating the solution and
project files worked fine.
Today, I tried to add new controls to an existing web form. The markup
doesn't show any errors, but in the auto generated code behind
(*.aspx.designer.cs) I am missing the declartion of the added...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
