I have a database with many tables related between them by account number. One of these tables contains the general data and demographics of all the records, but the other tables only contain a subset of records based on certain characteristics. I would like to be able to add new records to the general table any time that I add a record in one of the related tables, if it was not there before.
I selected the option "Allow creation of records in this table via this relationship" when I set the relationships between tables, but still, when I add a new record in one of the related tables it is not added within the general one. Any tip?