I work in ArcGIS 10.3 and I have this problem:
I have a dbf table of about 300 restaurants, each restaurant has a different values like address, number of seats etc. I have another dbf table of beers that are tapped in the above mentioned restaurants. For each record of a restaurant in the first table, there are one or many records in the second table, for example:
Restaurant "A", Elm Street 15 Restaurant "B", Ash Road 4
Restaurant "A", Elm Street 15, Beer_type1, Beer_type1_price Restaurant "A", Elm Street 15, Beer_type2, Beer_type2_price Restaurant "A", Elm Street 15, Beer_type3, Beer_type3_price Restaurant "B", Ash Road 4, Beer_type2, Beer_type2_price Restaurant "B", Ash Road 4, Beer_type3, Beer_type3_price
I'm trying to join (or relate?) the 2nd table to the 1st one, so I could see (hopefully in a single row) which beers are available in which restaurant. It would be something as "join one to many". I researched some but didn't find a suitable solution. I found very useful tool called "Add Relate" which is available only in ArcGIS Pro, so that's not an option. When done, I will add points (X,Y coords) of the restaurant to the map and each point should have attributes of the 1st table AND of the 2nd. Any tips how to handle this?