Howdy all. Brand new to this forum and pretty new to Access Coding. I've done JavaScript and some VB butanyway, here goes...
I'm using the Event management template from Microsoft but am trying to modify it.
I have three tables I'm working with. an Events table, a Vendors table and a VendorUsage table.
EVENTS is just a list of events
VENDORS is a list of vendors
VENDORUSAGE is a linking table that has fields for EventID and VendorID. So if Event 1 used Vendors 5 and 7, there would be one record with 1, 5 and one with 1, 7 showing that event 1 used vendor 5 and 7. Simple right?
My question is this.
On my Events Form I have a button and a dropdown box. The dropdown box is populated with the Vendor Names from the VENDOR Table. When I click the Button (Called AddVendor) I want to add a record to the VENDORUSAGE table with the EventID of the Event I'm viewing and the VendorID of the Vendor chosen from the dropdown box.
How do I code this?
If I left out any needed info, please let me know. Dropdown's name is Combo32 for now.
Thanks.
I'm using the Event management template from Microsoft but am trying to modify it.
I have three tables I'm working with. an Events table, a Vendors table and a VendorUsage table.
EVENTS is just a list of events
VENDORS is a list of vendors
VENDORUSAGE is a linking table that has fields for EventID and VendorID. So if Event 1 used Vendors 5 and 7, there would be one record with 1, 5 and one with 1, 7 showing that event 1 used vendor 5 and 7. Simple right?
My question is this.
On my Events Form I have a button and a dropdown box. The dropdown box is populated with the Vendor Names from the VENDOR Table. When I click the Button (Called AddVendor) I want to add a record to the VENDORUSAGE table with the EventID of the Event I'm viewing and the VendorID of the Vendor chosen from the dropdown box.
How do I code this?
If I left out any needed info, please let me know. Dropdown's name is Combo32 for now.
Thanks.
