Search results

Thanks! My coding isn't the best in the world, only just started to look at coding. I will have a look and see if i can get my head round the structure etc... Thank you.... I may be back with one or two questions :)

I have a form with a search text field, inwhich i want the user to type in a value to the search text and then I want a query which would search two tables and return which table the results in. i.e Form: Search Text Field ----> ABC12345 Table 1 Date Container Number -----> No Record of that...