Is there a way in Access to tie the same information to multiple records? Or to automatically populate a field in multiple records with information entered into only one place?
I have a database with info about buildings in several different cities. I have two problems:
1. Sometimes, there is information that applies to all the buildings in a city. I want a way to enter it only once and have that info somewhere on the record for every building in that city.
2. Sometimes I have important information that applies to a city, but no particular building in that city. It would be better if this info was not tied to every record in that city--it's a different kind of info so doesn't really make sense with the fields in the building records form. Any ideas for how to work this? Should I create a record for "general info" for a city and just ignore the fields except for comments? I could also create a new form with fields more appropriate to this info. If I did that, would the records still show up in my master table (this is desirable)? Both of these ideas seem kind of janky to me.
Access noob here (1 week at it). Please explain everything.
Thanks so much!
Beth