Hello everyone,
I am working on an automated script to pull menu information from two different tables based off of criteria in only only one table. I will attempt to illustrate my problem below:
We have two tables i need to draw from:
Beer_Locator & AVLBeerManager. AVLBeerManager contains all of the information about specific beers (ABV, Description, etc.) Beer_Locator contains all information about where the beer is currently on tap (we are a chain of beer bars that has multiple locations with different draft lines).
I have successfully filtered on Beer_Locator, and the records that were returned were correct, but I cannot determine how to link on the other table to draw the other information that i need.
I would like the results to look as follows:
[beer name] [beer style] [abv] [price]
[description]
Code is below:
<%for each d in Beer_Locator [(((Currently_On == "Yes" && Served == "On Tap") && Beer_Location == "Thirsty Monk South") && Tap_Location == "Main")]
{%>
<tr>
<td width="25%"><%=d.Beer_Name%> </td> <td width="25%"></td><td width="25%"></tr>
<td width="25%"></tr>
<tr><td align="left" colspan="4"> </td>
</tr>
<%}%>