I'm starting to think about how I might use some macros to improve on this, but for the moment it's bare bones. In Access it works very well and the link tables manage themselves! In LO you have to manually edit the link tables in a separate table. Implementing it in LO: Because in LO you can't edit a query based on more than one table (you can view it, but not edit it), like you can in Access, (and therefore you also can't build a form with a table that can edit a query based on more than one table), in LO this is not as clean as it is in Access. So the whole thing has maximum data flexibility: For example it allows for unlimited number of people per group, each person can have an unlimited number of phones or addresses, each address an unlimited number of people, etc. This allows any number of addresses per each group, and at the same time, any number of groups per each address. GroupAddress for example has GroupAddressID (the unique id for the link table itself), GroupID (which points to the Groups table), and AddressID (which points to the addresses table). Unlike the video you cite above with only 2 fields, in my link tables there are 3 fields. And there are 6 link tables to connect those primary tables: GroupAddress, GroupPhone, GroupPerson AddressPhone, AddressPerson and finaly PhonePerson. It has 4 primary data tables: Groups, Address, Phones, and People. I have a complex many-to-many contacts structure that I'm in the process of porting from MS Access to LibreOffice.
The author could have simply added a Movie ID field to the genre Table, (so multiple genre records can point to each movie record). In the video you cite, this is kind of silly as there is no need for a many to many relationship. I assume there's something obvious that I'm missing, but at this point I'm pretty stuck.Į: I took more screenshots to show the relationships, tables, and how things connect in the form: Integrity constraint violation - no parent SYS_FK_94 table: Address Table in statement So I followed along with the video, but set the columns to "combo box" instead of "list box." However, when I try that I get an error message:
I watched this youtube video, which was very helpful, but I want to be able to add new cities instead of only selecting from a pre-established list. Now I want to add everything into a single form. I've also created a junction table with Contact ID and Address ID, and connected the three tables using the relationships tool. I've created an address table with an Address ID, City, State, etc. I've created a simple contacts table with the Contact ID, Last Name, and First Name. Many of our contacts have multiple addresses (office, mailing, home), and sometimes multiple people have the same address.
I am essentially trying to create a glorified contacts list using LibreOffice Base.