We a have a joomla based site which has two different components which utilize location/address information.
Problem is the two have locations which should be visible and shared between the two. Example, for the one component, if a venue is added there we would like it automatically added it to the other component's related table.
How can we automatically eliminate dupes within the individual tables and also between the two?
This may also involve addition of a small text string added to joomla's jos_content table. One of the two components works in concert with Joomla's article/content system. So effectively when you add a new listing, you are creating a new content item in joomla. And joomla requires that at the creation of a new article, that there be some content in the description field, So we just to create/add/or copy a simple text string to that field.
Extensive database and joomla "rated" experienced required.