AnsweredAssumed Answered

Pop-up field for all records from table having "blank" for one field

Question asked by boydcrow on Nov 9, 2011
Latest reply on Nov 9, 2011 by philmodjunk

Title

Pop-up field for all records from table having "blank" for one field

Post

I'm trying to make an entry form for computers at our installation in a table called computers. I have a complete list of all accessible IP addresses in a related table. The tables are related by indexed fields called "computer".

I want to have a field where the user can look up all unused IPs by having them displayed in a pop-up field.  "Unused" IPs are defined as having a blank entry in the computer field. 

I can't use a calculated field because I want fields from multiple records returned which doesn't seem to work.

I can't use a portal because there is no current record value to relate to the table of the portal.  I want everything that has blank computer, regardless of the current fields in the current layout.

Basically, I want to display a filtered table in a pop-up field on a layout based on a different table.

Any ideas?

Outcomes