I'm creating a database to keep track of our IT dept servers.
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?