We need some recommendations on good solid database design for the following scenario with an MS Access Database.
We have a list of the URLs assigned to each offering where we display a list of the translated web pages for every single offering we have (one-to-many relationship). The URLs are stored in a "short text" field and after that we use a custom code in order to follow a hyperlink.
Should we switch the data type to be "hyperlink" instead of "short text", and how would it be affected in the GUI? Note that we may use that URL in our custom export procedure (we may export it to text file, we may copy it to clipboard, or we may as well combine it with some other piece of information from our DB and display it all together in a text file, it all depends on a type of the template we use during the export procedure). We also need to open a webpage on that URL through the GUI, but that part is fixed through the code.