I think we have a misunderstanding here because of the naming convention, and definition of what a table is.
A table (also called "entity") is a structure that represents the business object. Every table has its own name and set of columns (also called "fields") where the attributes, properties, and actual data are stored. Typical examples of tables are Contact (represents a physical person with attributes like name, birthdate, gender, address, phone number), Accounts (for companies: name, tax number, address, type of industry), invoices (obviously - document identifier, total value, seller and customer data.
Every table stores data in the form of rows, often called "records". A record is an instance of an object defined by the table. Sample record for the Contact table may look like this:
First Name: John
Last Name: Smith
Birthdate: 1980-11-12
Gender: Male
Creating a table means to prepare a data structure for the records (creating fields, forms, views and so on). For example, you can create a new table "Holiday Request" and add fields like "Employee", "Start Date", "End Date", "Status".
Creating a record means to fill a previously prepared table with properties of a given object. According to the previous example - the record of "Holiday Request" may look like "John Smith", "2023-08-01", "2023-08-15", "Rejected".
We only create tables during development to prepare a convenient environment for the users, enabling them to create records of tables we created for them. Our applications usually don’t automatically create new tables, but they create new records for previously prepared tables.
As far as I understand you want to create an app where you store (in tables;)):
• Employees of your organization
• Training records related to them
Additionally, you want to create automation that triggers every time you add a new Training record, which should update the related Employee record. For example - if I add new Training record to my Employee John Smith, the system should automatically update the field "Last training date" on John Smith's Employee record.
Beyond that you want to use some color coding to highlight data if it meets relevant conditions.
Am I right?
