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=tblContractorID, FK is tblAudit IDTable
5. SubContractor Designation field
SubContractor Table - PK=tblSubcontractorID, FK=tblContractorID -
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  1819 
On Dec 12, 11:13 pm, Elfae <nanc...@efn.orgwrote:
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=tblContractorID, FK is tblAudit IDTable
5. SubContractor Designation field
SubContractor Table - PK=tblSubcontractorID, FK=tblContractorID -
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.orgwrote:
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=tblContractorID, FK is tblAudit IDTable
5. SubContractor Designation field
SubContractor Table - PK=tblSubcontractorID, FK=tblContractorID -
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.orgwrote in news:dc34b98b-d20e-45b9-89c7- a8**********@d21g2000prf.googlegroups.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=tblContractorID, FK is tblAudit IDTable
5. SubContractor Designation field
SubContractor Table - PK=tblSubcontractorID, FK=tblContractorID -
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.orgwrote in news:dc34b98b-d20e-45b9-89c7-
a8fabbe70...@d21g2000prf.googlegroups.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-generatedincrease in
two of a three-part field - one numeric the other text. The Org
Number, IncrementalNumber, and Subcontractor Designation make up the
Audit Identificationnumber(7) for queries and reports. There is a
hyphen between OrgNumberand IncrementalNumber. 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. IncrementalNumberfield (numeric)
4. Contractor Name field
Contractor Table PK=tblContractorID, FK is tblAudit IDTable
5. SubContractor Designation field
SubContractor Table - PK=tblSubcontractorID, FK=tblContractorID -
covers 5 & 6
6. SubContractor Name
7. Audit IdentificationNumber- 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 anexistingrecord 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 Incrementalnumber(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 Incrementalnumber(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.orgwrote:
On Dec 14, 5:09 am, lyle fairfield <lylef...@yahoo.cawrote:
Elfae <nanc...@efn.orgwrote in news:dc34b98b-d20e-45b9-89c7-
a8fabbe70...@d21g2000prf.googlegroups.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-generatedincrease in
two of a three-part field - one numeric the other text. The Org
>Number, IncrementalNumber, and Subcontractor Designation make up the
Audit Identificationnumber(7) for queries and reports. There is a
hyphen between OrgNumberand IncrementalNumber. 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. IncrementalNumberfield (numeric)
4. Contractor Name field
Contractor Table PK=tblContractorID, FK is tblAudit IDTable
5. SubContractor Designation field
SubContractor Table - PK=tblSubcontractorID, FK=tblContractorID -
covers 5 & 6
6. SubContractor Name
7. Audit IdentificationNumber- 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 anexistingrecord 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 Incrementalnumber(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 Incrementalnumber(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*******************@read1.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.orgwrote in
news:1ffb3fa9-8215-4ff5-934b- 6d**********@a35g2000prf.googlegroups.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...
|
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...
|
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...
|
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...
|
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...
|
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"....
|
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...
|
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...
|
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...
|
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: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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: 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:
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: 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,...
| |
