B
Barry A&P
I have a database to track parts being ordered. I have been having issues
with parts that have been superceeded by newer parts. I have a Parts Table
as follows
T_PartNumbers
PartNumberID (pk)
PartNumber
Description
and a order list
T_PartsOrder
OrderID (pk)
PartNumberID (fk)
Qtytoorder
DateRequested
I have a form based on my T_Parts with a lookup Control FindPartNumberID_Combo
When a part is selected in the combo the form goes to that Partnumbers
Record (this was done with the Wizard) I am hoping for help with a function
that would check to see if the partNumber being looked up is superceeded and
if so have a dialog box pop up that would give me the option of selecting the
"Old" Part number or the "New" Partnumber then have the form jump to
whichever is selected.
I am thinking maybe a third table T_Superceededparts
ID (pk)
PartNumberID (fk)
NewPartNumberID (fk)
and some code for the lookup that might check this table first and if the
PartNumberID is found show a dialog box that will let me proceed with either
option.. Maybe im off base with my idea. The people that know what they are
doing seem to always have the most Elegantly Simple answers..
Im open to any ideas
Thanks
Barry
with parts that have been superceeded by newer parts. I have a Parts Table
as follows
T_PartNumbers
PartNumberID (pk)
PartNumber
Description
and a order list
T_PartsOrder
OrderID (pk)
PartNumberID (fk)
Qtytoorder
DateRequested
I have a form based on my T_Parts with a lookup Control FindPartNumberID_Combo
When a part is selected in the combo the form goes to that Partnumbers
Record (this was done with the Wizard) I am hoping for help with a function
that would check to see if the partNumber being looked up is superceeded and
if so have a dialog box pop up that would give me the option of selecting the
"Old" Part number or the "New" Partnumber then have the form jump to
whichever is selected.
I am thinking maybe a third table T_Superceededparts
ID (pk)
PartNumberID (fk)
NewPartNumberID (fk)
and some code for the lookup that might check this table first and if the
PartNumberID is found show a dialog box that will let me proceed with either
option.. Maybe im off base with my idea. The people that know what they are
doing seem to always have the most Elegantly Simple answers..
Im open to any ideas
Thanks
Barry