Cabling Data base with Base

[JoãoRodrigues]

Hello.

My goal is to replace the .ods file of my data center cabling system with a .odb file for better data insertion and search.
As being new at this, I’m starting with simple table.

Objective: a Table with the following field (columns):

1 - Cable tag

2 - Endpoint 1 (composed of three parts “Device type”, “Device” and Port Device")

3 - Endpoint 2 (composed of three parts “Device type”, “Device” and Port Device")

Four tables were created with only one field for no repetitions (Cables_Tags, Device_type, Device, Port_Device)
A Form with combo boxes was made for the insertion of this objects.

From here I’ve tried several ways but never got results. Mixed up with relationships, how to create a table with 2 endpoints that get info from other tables? Does anyone have any ideas? Help?

Tanks.

[iplaw67]

In order to use foreign keys efficiently, each table should have a primary key in addition to the fields you have set out in your question, and Cable-tags could contain foreign key references pointing to the INT ID fields of your Endpoint tables. This is not really a LibreOffice problem though, more one relating to SQL normalisation.