M
Mark
Rod,
Access doesn't have record triggers at the table level
like Oracle does. In order to do what you wish, you'll
have to create a form (you should be doing this anyway
because you NEVER EVER want a user to access the data
from the tables). Then add an AfterUpdate event to the
Section tasked field.
Mark
WorkorderID field.
equipment under the Acquisition table. What I am trying
to figure out is a way for when the record under the
WorkOrder table is completed and the Section Tasked field
entered (Not NULL), that a new record in the Acquisition
table will be entered with the WorkOrderID already there.
record under the Acquisition table and select the
WorkOrderID.
Access doesn't have record triggers at the table level
like Oracle does. In order to do what you wish, you'll
have to create a form (you should be doing this anyway
because you NEVER EVER want a user to access the data
from the tables). Then add an AfterUpdate event to the
Section tasked field.
Mark
before, but I am on time sensitive deadline.-----Original Message-----
I appologies upfront if this question has been asked
Acquisition table. The two tables are linked by theWhat I have is two tables. A Workorder table and an
WorkorderID field.
(SectionTasked) that designates a section that will buyIn populating the Workorder table, there is one field
equipment under the Acquisition table. What I am trying
to figure out is a way for when the record under the
WorkOrder table is completed and the Section Tasked field
entered (Not NULL), that a new record in the Acquisition
table will be entered with the WorkOrderID already there.
seems fine except that the user has to manually add aI have joined these two table in a select query, and all
record under the Acquisition table and select the
WorkOrderID.