Hello, I have two tables with ID Leden (Integer), how do I maintain certain data from table 2 into a form based on table 1. e.g. Form table 1 gives all fields, but i need address field from table2.
Help?
Hello,
You should have a relationship established between the records of the two tables. Table two will have its’ own ID field but additionally a second linked field containing the ID of the record it relates to in table one. Most often this is a one-to-many relationship.
Then on the form you have the table one records and establish a sub form with table two records. There is a property to link the two. This allows the sub form to display related records of the form.
For additional information, see:
Form Design
and/or
LibreOffice Base Guide Chapter 4 - Forms.
To understand how to create a relationship between tables and to get an idea of what they are, a tutorial: