Hi All
I've been looking for a solution to this problem for a while now, and through surfing these forums everytime I think I find a solution, I only end up confusing myself more! So before I break out the bottle of Scotch in frustration, I thought I'd better post the problem to see if I can get a resolution before I drive myself totally MAD!!
I have two databases that were created at different times to serve different needs. Now I find that I need to use information from one DB in the other to save a ton of retyping. Essentially, here is what I have:
A table in one DB (Assets) that I need some information in another DB (Inventory). So I created a link to the source DB (Assets) with which I now need to be able to get the information from the 'location' field to display in a combobox on a form in the inventory DB.
When I create the lookup for the combobox in the inventory form, I get the information I need, however it is duplicated 178 times as opposed to only once as it displays in the form in the Assets DB.
I need to track parts used in equipment that is in the Assets DB. There is over 200 pieces of equipment in four different locations. So when a new piece of equipment is added in the Assets DB, it is assigned a location from the form's drop down combobox which only lists the four location choices. However in the inventory combobox, when a part from inventory is matched to a piece of equipment, the first combobox to use is the location box to narrow down the selection, but the combobox displays every location that was ever used in a record in the Assets DB. In other words, I would have in the box 100 "Main", 52 "TMD" choices etc. When in fact there is only 1 "Main" location etc.
What I need is to have only the four locations show in the combo box for selection.
I hope this description isn't too long winded and confusing. If anybody has any solutions or needs more clarification, I am willing to answer all questions.
I've been looking for a solution to this problem for a while now, and through surfing these forums everytime I think I find a solution, I only end up confusing myself more! So before I break out the bottle of Scotch in frustration, I thought I'd better post the problem to see if I can get a resolution before I drive myself totally MAD!!
I have two databases that were created at different times to serve different needs. Now I find that I need to use information from one DB in the other to save a ton of retyping. Essentially, here is what I have:
A table in one DB (Assets) that I need some information in another DB (Inventory). So I created a link to the source DB (Assets) with which I now need to be able to get the information from the 'location' field to display in a combobox on a form in the inventory DB.
When I create the lookup for the combobox in the inventory form, I get the information I need, however it is duplicated 178 times as opposed to only once as it displays in the form in the Assets DB.
I need to track parts used in equipment that is in the Assets DB. There is over 200 pieces of equipment in four different locations. So when a new piece of equipment is added in the Assets DB, it is assigned a location from the form's drop down combobox which only lists the four location choices. However in the inventory combobox, when a part from inventory is matched to a piece of equipment, the first combobox to use is the location box to narrow down the selection, but the combobox displays every location that was ever used in a record in the Assets DB. In other words, I would have in the box 100 "Main", 52 "TMD" choices etc. When in fact there is only 1 "Main" location etc.
What I need is to have only the four locations show in the combo box for selection.
I hope this description isn't too long winded and confusing. If anybody has any solutions or needs more clarification, I am willing to answer all questions.
