A
AWM
I would like to create a form (with query) that would allow the user to
programatically update a part number and revision level when a change
to the part is required. I have created two tables; tbl_parts and
tbl_partRev with a 1 to many relationship.
I have two questions...
1. Assuming the operator has loaded a part and part revision
information for a given part number into the db, I would like to create
input form(s) that would allow the operator to create a new part
revision level copying the information from the previous level to the
new level. The operator would then change controls in this form
(copied from the previous revision level) in order to create the new
part revision level. I have assumed I need (at a minimum), two tables,
tbl_Part and tbl_PartRevision with a 1:M relationship. Question... I
have never designed a db for part number and rev level management so is
the form logic as outlined above recommended as "best practice" db
design for similar applications? Could you recommend an example that I
can review to learn more about how to develop the input forms of this
db?
2. Currently we are managing this information with Excel. The part
revision levels are text format (i.e. revision level A, B, C, D,
etc....). I would like to keep the revision level as a text field (too
many part numbers to change), but do not know the code or macro method
to determine the next highest letter in a table column. Please advise
the code/macro method that can be used to find the next highest letter
in a table.
Thank you.
programatically update a part number and revision level when a change
to the part is required. I have created two tables; tbl_parts and
tbl_partRev with a 1 to many relationship.
I have two questions...
1. Assuming the operator has loaded a part and part revision
information for a given part number into the db, I would like to create
input form(s) that would allow the operator to create a new part
revision level copying the information from the previous level to the
new level. The operator would then change controls in this form
(copied from the previous revision level) in order to create the new
part revision level. I have assumed I need (at a minimum), two tables,
tbl_Part and tbl_PartRevision with a 1:M relationship. Question... I
have never designed a db for part number and rev level management so is
the form logic as outlined above recommended as "best practice" db
design for similar applications? Could you recommend an example that I
can review to learn more about how to develop the input forms of this
db?
2. Currently we are managing this information with Excel. The part
revision levels are text format (i.e. revision level A, B, C, D,
etc....). I would like to keep the revision level as a text field (too
many part numbers to change), but do not know the code or macro method
to determine the next highest letter in a table column. Please advise
the code/macro method that can be used to find the next highest letter
in a table.
Thank you.