I don't really follow your problem.
You have a table of breweries.
You have a table of beers.
Redhook gets a new beer you insert a 7 for a beer id, "Longhammer" as a name, and 4 for a brewery.
beerid beername breweryid
1 Ranier 1
2 Country Club 2
3 Bailey's Special Picnic 2
4 Our Pride 3
5 Blackhook 4
6 ECS 4
Boom, simple, you are done.
You obviously know what you are doing and you have a nice site, so I think maybe you are just not making yourself clear as to what you want.
"Inserting records to connect data" makes little sense to me. ASP is just the server side language being used to construct the HTML presentation- it doesn't have a anything to do with the data structure. MSSQL can do anything and more than Access,
"any record in any table relative to any other record in any other table if that makes sense." Sorry, but it doesn't.
What do you want?
Brinkster- free development account. Not affiliated, but I sure like free. Brinkster.com