Newbies BCA Posted April 24, 2017 Newbies Posted April 24, 2017 I have a database that keeps track of computer system information. I have a record for each system (one per room). Within this system there are a number of different computer devices and I want to track settings such as IP addresses subnet masks and other network type information. I have a table called “Systems” and I’m using tabs to separate the different devices within a system. Within each separate tab do I need to create a unique field for each piece of information or is there a more efficient way to do this? For example: the first field would be device one IP address the second field would be device one subnet mask The third field would be device one preferred DNS The fourth field would be device one IP address The fifth field would be device one subnet mask The sixth field would be device one preferred DNS Etc. Seems like I’m missing something and there might be a more efficient way. Thank you for any help.
comment Posted April 24, 2017 Posted April 24, 2017 (edited) 37 minutes ago, BCA said: Within this system there are a number of different computer devices If one system can have multiple devices, then you have a one-to-many relationship between Systems and Devices - and you should use a portal to display the related records from Devices on a layout of Systems. A tab control is not really suitable for this - it is a layout-level device meant to switch between objects on the current layout, not between different records. To view the details of one device at a time, see: http://fmforums.com/topic/71867-getting-more-out-of-filtered-portals-2view-selected-child/ Edited April 24, 2017 by comment
Lee Smith Posted April 24, 2017 Posted April 24, 2017 Hi BCA and welcome to the FM Forums, Are you using FileMaker Pro 12, or were you referring to the file ext of .fmp12, because Sliders weren't introduced until version 13? Lee
Fitch Posted April 24, 2017 Posted April 24, 2017 Who said anything about sliders (or slide controls)? the first field would be device one IP address... The fourth field would be device one IP address I'm thinking you meant: The fourth field would be device TWO IP address ... etc. As comment said above, with a table for "device" you'd only need those first three fields. Each device would get its own record.
Recommended Posts
This topic is 3021 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now