enter 'afterupdate' into form text boxes (I think)

[Astrid]

Hello, I'm not sure how to do this.

I have 2 tables in a 2003 database - tblRequisitions (with RequisitionNo,
RequisitionDate, Company, Details, Notes) and tblDetails (with loads of
fields including RequisitionNo, RequisitionerName, Department, Goods,
PONumber, GRNumber, GRDate, etc). PONumber = Purchase order number, GRNumber
= Goods Receipt number.

Because for each requisition number there can be several associated PO
numbers, I have created a one-many relationship between the tables
(requisition numbers to details).

I have created linked forms to add the requisitions to the database - first
form containing the tblRequisition fields, then linking to a form containing
the fields for tblDetails, and I have 2 questions:

1. Is there a way to make it so that I can enter the requisition details
(and RequisitionNo) once and it will automatically add that requisition
number to the tblRequisitions AND tblDetails information without having to
enter it again into the tblDetails linked form

2. Would it work to set the tblRequisitions form text boxes to update after
they have been changed, then on the linked details form have a look-up combo
box to choose the requisition number from (to avoid human error as the
numbers can get quite large) - and if this would work what would be the code
that I need to enter as I am unsure what it needs to be.

Hope this makes sense,

Astrid x

 

[NetworkTrade]

your RequisitionNo is the cross referencing field

in Forms Design Mode when you have the main form based on the Requisition
Table and then go to insert a subform based on the Requisition Table - the
wizard will launch to link these two cross reference fields together.

this will basically satisfy both your questions....