Documentation

To add foreign keys, you should proceed to Step #2.

Click on the settings icon located under the page where you want to implement a forign key field

1. Click the "Add New Field" button.
2. Choose the "int" field type.
3. Write the table name followed by "_id". For example: emp_information_id, countries_id, cities_id.
4. Important: Do not attempt to modify the field size when adding a foreign key field.
5. Choose whether the field should accept null values or not.
6. Specify the sort order for the field.

By following these steps, you can add a new foreign key field to your system.

1. After configuring the foreign key field, click "Save."
2. Then, under the field you've added, choose the specific field from which you want to retrieve data. This selection will determine the data fetched from the related table.