S
skeetermouse
I have created a Main Form (linked to a parent table), and a subform with
child records from a second table. The main table is a list of VENDORS, and
the child table is a list of ADDRESSES. These tables have a linked
relationship. I have been able to successfully create a lookup of child
records using a combo box attached to the VENDOR NAME filed of the parent
table.
Key fields in VENDOR table:
CONTACT_ID
COMPANY_NAME
AP_VENDOR_NUMBER
AP_VENDOR_ID
TAX_ID_NUMBER
Key fields in VENDOR_ADDRESS table:
RECORD_ID
CONTACT_ID
COMPANY_NAME (yes I know this is not normalized)
AP_VENDOR_NUMBER
AP_VENDOR_ID
I also have a linked table to our main Oracle database for the PO_VENDORS
table. PO_VENDORS includes a VENDOR_ID (that corresponds to AP_VENDOR_ID),
and SEGMENT1 field (that is the AP_VENDOR_NUMBER). Users can view SEGMENT1
(VENDOR_NUMBER) in Oracle, but they do not know the VENDOR_ID. Since they
know the SEGMENT1 (vendor#), when they open the Access form they will be
updating an AP_VENDOR_NUMBER field. When they enter the AP_VENDOR_NUMBER, we
need to update the AP_VENDOR_ID on both the VENDORS and VENDOR_ADDRESSES
table. I can do this using an UPDATE query in Access, but I want to
incorporate this into an Access form called UPDAPVENDOR. The update query
updates the field VENDORS.AP_VENDOR_ID where the PO_VENDORS.SEGMENT1 =
VENDORS.AP_VENDOR_NUMBER.
I have tried using the Expression Builder to create the CRITERIA for the
UPDATE query to point to the value of FORMS!UPDAPVENDOR!AP_VENDOR_NUMBER text
box, but this value does not seem to register from the form entry.
Can anyone suggest what Access methods should be used to accomplish this?
Thank you for any help you can give,
Brenda
child records from a second table. The main table is a list of VENDORS, and
the child table is a list of ADDRESSES. These tables have a linked
relationship. I have been able to successfully create a lookup of child
records using a combo box attached to the VENDOR NAME filed of the parent
table.
Key fields in VENDOR table:
CONTACT_ID
COMPANY_NAME
AP_VENDOR_NUMBER
AP_VENDOR_ID
TAX_ID_NUMBER
Key fields in VENDOR_ADDRESS table:
RECORD_ID
CONTACT_ID
COMPANY_NAME (yes I know this is not normalized)
AP_VENDOR_NUMBER
AP_VENDOR_ID
I also have a linked table to our main Oracle database for the PO_VENDORS
table. PO_VENDORS includes a VENDOR_ID (that corresponds to AP_VENDOR_ID),
and SEGMENT1 field (that is the AP_VENDOR_NUMBER). Users can view SEGMENT1
(VENDOR_NUMBER) in Oracle, but they do not know the VENDOR_ID. Since they
know the SEGMENT1 (vendor#), when they open the Access form they will be
updating an AP_VENDOR_NUMBER field. When they enter the AP_VENDOR_NUMBER, we
need to update the AP_VENDOR_ID on both the VENDORS and VENDOR_ADDRESSES
table. I can do this using an UPDATE query in Access, but I want to
incorporate this into an Access form called UPDAPVENDOR. The update query
updates the field VENDORS.AP_VENDOR_ID where the PO_VENDORS.SEGMENT1 =
VENDORS.AP_VENDOR_NUMBER.
I have tried using the Expression Builder to create the CRITERIA for the
UPDATE query to point to the value of FORMS!UPDAPVENDOR!AP_VENDOR_NUMBER text
box, but this value does not seem to register from the form entry.
Can anyone suggest what Access methods should be used to accomplish this?
Thank you for any help you can give,
Brenda