Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 2761 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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.

Posted (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 by comment
Posted

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

Posted

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.

 

This topic is 2761 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.