How to make values in one table automatically show in another table?

[nameit]

Hi, I have a problem, I have a table were I list networkservices and their logical ports and I have another table were I list IPaddresses used by different machines. I'm using a multivalued lookupfield to pick which services I'm using for each Ipaddress, and thats working fine, but now I want to make the ports which is listed in another column, to automatically show in it's own column in the IPaddresses table depending on which services I'm choosing for the different IPaddresses. Is this possible?, and if it is how can I make this happen?

 

[Roly Reefer]

Hi,

You can't do that - it's very dangerous because you could knacker your data. It's also unnecessary data to have data duplicated and makes the database larger and slower.

You should just run queries that take the data from both tables - it's much safer and quicker to run.

All the best,


Roly