AnsweredAssumed Answered

Portal to show all records for selected record

Question asked by alternapop on Feb 29, 2016
Latest reply on Mar 1, 2016 by alternapop

I'm creating a database to keep track of our IT dept servers.


Screen Shot 2016-02-29 at 11.13.45 AM.png



It's similar to a Customer > Invoices > Invoice type setup.


The 'server' table is the main database where each server gets entered. Because each server can have many 'MAC addresses', 'IP addresses', and 'domain names', I've created a table for each.


It's working except I'd like to have a portal show ALL domain names for a single server record that's being looked at.


I've tried creating a new table occurrence for "domain_names", as shown in the image, and linked it to both:

• domain_names__server::server_addresses_fk  X  server::ID

• domain_names__server::MAC_addresses_fk  X  MAC_Addresses::ID (shown in the image... the table occurrence name is just left over from the previous attempt to get it working when it was linked to 'server')

in both cases it shows ALL domain names for ALL records, which is not what I want.

What do I need to do?