I have table within our database that stores all the text values for a series of dropdown boxes in our database. Depending on what you select in the first drop down box determines what you can select in the next. I am trying to build a report that will display the text values from each drop down. The table contains two fields one is a code which refers to the certain dropped down table and also a field which displays the the text. The problem I have is that once I have managed to obtain the first set of text I am unable to use the same field again as I have already defined it as a certain value. Is there a way I can rename the field for the first set of data, so I can use the field again to retrieve the next set of data?
Links removed - pootle flump