This question is similar to one I posted yesterday, but with a twist. I need to be able to pull data from a table (product_status, which has many other fields) and cross reference it with data in another table (warranty). The data in product_status lies in a field called warranty_number, and is simply an id number (1,2,36,etc.) The data in table warranty, field warranty_comment, is text (30 day warranty, one year warranty, etc.). The warranty table also has a field called warranty_id, which corresponds to each text entry in the table. This number matches the number in table product_status, field warranty_number. So I need to be able to print results of product status, but instead of printing simply the number in field warranty_number, it needs to check table warranty, field warranty_id, then match the number, then pull the text from warranty_comment and print along with all the other results from product_status. I have some code that works, but it is not at all designed for this, so I won't post. Is this enough info to explain what I need? I have tried searching, but found nothing that I could see that would help. Thanks in advance.
