Thank you,
Im hoping you all can help me further with this subject.
I now have two separate price sheets in my database, They both have the same structure in each table.
One table is named as was listed above, 'prices' the new table is named 'pricesf'
What I need to do is to pull the data out of 'pricesF' table IF that particular links record has the word 'Foil' in one of the columns in it's record. If it's got the word 'Not Foil' then it should pull the price data out of the original 'prices' table like it's doing now.
OR if it's easier, maybe it could just bring back the data from both tables, and show the letter F before the price from the 'pricesF' table.
Is that doable?
Im hoping you all can help me further with this subject.
I now have two separate price sheets in my database, They both have the same structure in each table.
One table is named as was listed above, 'prices' the new table is named 'pricesf'
What I need to do is to pull the data out of 'pricesF' table IF that particular links record has the word 'Foil' in one of the columns in it's record. If it's got the word 'Not Foil' then it should pull the price data out of the original 'prices' table like it's doing now.
OR if it's easier, maybe it could just bring back the data from both tables, and show the letter F before the price from the 'pricesF' table.
Is that doable?