Hello! I’m new with databases- I get it, I “understand” the relations, etc. But I’m horrible with organizing tables properly i.e. “Do I make a separate table for these objects?” etc. (Just to give an idea of where I stand) So I’ve read through other examples such as here: Building your own database without technical experience // Baserow and have used it to more or less guide/translate it into the fields I need.
So the closest I came to anyone discussing my dilemma is here: Prefill form with record info to update records
I’d like to explain my issue not only for assistance but also to provide a real world scenario.
What I’ve got is 15 Cisco 52 port switches at different locations and all with several VLANs/trunks assigned on each port. What I’m trying to do is make a simple form for the junior (and some senior) techs to be able to update a change to one of the ports.
I have 2 tables, a PORT table w/single field of 1-52 and a VLAN table w/single field of the various vlans listed.
On another table I have set to the location for example, “Room1 switch” with 2 fields. One linked to the PORT table and the other linked to the VLAN table. And that’s basically it.
Works great except that if I make a form rather than manually filling the cells, it adds another record. So the first record is port 1 with vlan 55, lets say. And after using a form it will add at the very bottom the same port but now with a different vlan. Which record is correct? Hence my dilemma. In Access or Libre Base this would (I THINK) be akin to setting the “update cascade” option when creating a relation.
Unless I’m just approaching this wrong from the outset? Another “argument” (if you take my meaning) is if I had to update a single record out of 2000, rather than sorting or filtering, would it not be easier to just open a form, refer to some fields and make the change? I hope that makes sense. Furthermore, even if I’m manually updating each cell, how does one know if a duplicate isnt being created? Lets say out 2500 records?
Any help would be greatly appreciated! Thanks!