D
D. M.
Hello all,
HELP!! I am trying to create a form to input maintenance requests. There
are 3 tables: stores (StoreID-PK), vendors (VendorID-PK, RequestID-FK),
requests (RequestID-PK, StoreID-FK, VendorID-FK). Here are the problems:
I am trying to use 2 combo boxes:
1. To choose the store (by StoreID) and show it's address, etc. in
corresponding text boxes; and
2. Another combo box to choose the vendor (VendorID), and show it's
address, etc. in corresponding text boxes.
I can one or the other to work and correspond with the requests data. But I
can't get BOTH to work.
The first question which table should this request be based on (stores or
maintenance), or should there be subforms for the stores and vendors? I've
tried it all ways, attempting to duplicate code from the Northwind Orders
form. But I've failed.
Any help would be greatly appreciated... what hair I have left (since I
haven't pulled it out) with also thank you!!
HELP!! I am trying to create a form to input maintenance requests. There
are 3 tables: stores (StoreID-PK), vendors (VendorID-PK, RequestID-FK),
requests (RequestID-PK, StoreID-FK, VendorID-FK). Here are the problems:
I am trying to use 2 combo boxes:
1. To choose the store (by StoreID) and show it's address, etc. in
corresponding text boxes; and
2. Another combo box to choose the vendor (VendorID), and show it's
address, etc. in corresponding text boxes.
I can one or the other to work and correspond with the requests data. But I
can't get BOTH to work.
The first question which table should this request be based on (stores or
maintenance), or should there be subforms for the stores and vendors? I've
tried it all ways, attempting to duplicate code from the Northwind Orders
form. But I've failed.
Any help would be greatly appreciated... what hair I have left (since I
haven't pulled it out) with also thank you!!