Guest_imported
New member
- Jan 1, 1970
- 0
I have a database that contains a link table, consisting of the following four fields:
Location
Type of Service
Vendor
Preference Number
This table is used to track which vendors service a particular service type for each location (50,000+ records).
I'm trying to setup a form that will allow a user to go in and assign a vendor and it's preference # to a Type of Service for a location. Right now, the preference #'s are all over the place. For example, a location may have four vendors linked for HVAC, the first having a prefernence # of 1, the second being prefernece 2, the third being preference 5, the fourth being preference 11. My form needs to take a list supplied by the user (containing all four fields) and update this table (adding a vendor/preference number for a location/service). I need it to be able to verify the existing links and adjust the preference numbers accordingly. For example, if the user is adding a new vendor for HVAC at preference #1, the the existing vendor with a preference of 1 will have to be changed to preference 2, the vendor at pref. 2 will need to be moved down to pref. 3, etc. I want this process to occur only until it adjusts the existing links until there are no duplicates. Using my prior example, it would adjust the links with a pref. # 1 and pref. # 2, but would leave the links at pref. # 5 and pref. # 11 alone. I hope this is making sense to everyone, because I think I've managed to confuse myself with this email.
Any help would be greatly appreciated. Thanks in advance.
- Brian
Location
Type of Service
Vendor
Preference Number
This table is used to track which vendors service a particular service type for each location (50,000+ records).
I'm trying to setup a form that will allow a user to go in and assign a vendor and it's preference # to a Type of Service for a location. Right now, the preference #'s are all over the place. For example, a location may have four vendors linked for HVAC, the first having a prefernence # of 1, the second being prefernece 2, the third being preference 5, the fourth being preference 11. My form needs to take a list supplied by the user (containing all four fields) and update this table (adding a vendor/preference number for a location/service). I need it to be able to verify the existing links and adjust the preference numbers accordingly. For example, if the user is adding a new vendor for HVAC at preference #1, the the existing vendor with a preference of 1 will have to be changed to preference 2, the vendor at pref. 2 will need to be moved down to pref. 3, etc. I want this process to occur only until it adjusts the existing links until there are no duplicates. Using my prior example, it would adjust the links with a pref. # 1 and pref. # 2, but would leave the links at pref. # 5 and pref. # 11 alone. I hope this is making sense to everyone, because I think I've managed to confuse myself with this email.
Any help would be greatly appreciated. Thanks in advance.
- Brian
