Pop-up field for all records from table having "blank" for one field
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.