How to update new art shows at Galleries which have multiple locations.
I have a Gallery Table and an Address table that have a relationship. I enter the Gallery name and then have a portal for the address. Each address has different art shows every 5-6 weeks. What do I do if I would like to create a table/ field/ relationship (not sure how to do this) of the shows that are happening at the various addresses under 1 Gallery. The address would stay the same, but the shows change. Also how would I then bring up the most recent ones i.e. those that are starting say Feb 1?
Any help on how to create this would be great because I am hot sure how to link the address and continually update the shows at that address.