Hello,
I started using Access on my own without following any training so to all "pure" access minds reading this please apologise the amateurism.
My main table of the database, containing 800++ records, weights 2gb. I have attached many documents to many records hence the weight.
One of the fields of the records is the city. Basically, I know for the moment it is London, but in the future it could some other cities.
In order for me to manage a database that has a more manageable size, I was thinking of splitting the table (I read somewhere on this forum this was usually done to allow multiple users working on the same database).
That is, the tables would have exactly the same structure, but one would be for all records with the criteria "London", and one sub-table per city. Each of the tables would be an external file saved somwhere safe, and when I open my access file, I have all the tables linked to my interface.
I have already linked to my form a table of cities, so basically, whenever I want to add a new city, I update my table "cities" then it appears in the drop-down list of my form when I create or update my record.
Now, if I split my main table into several sub-tables in order to contain the size of each, I would need a way to make Access populating my record in the relevant table as soon as I choose or update the "city" in my drop-down list. Of course I would also need a way to forbid the creation of a new city in my table "cities" if there is not a corresponding table already created.
Is this possible?
thanks a lot