brain cramp on connecting related fields

[Mark Reed]

Im having a total brain cramp.

I know how to connect a portal to show direct one to one relations... however, my situation is this:

I have a table called LOCATIONS. In it is locID, locName, locDescrip

I have several other tables - a Food table, a Water table, and a Utensils table.

Each of those three tables use the Locations table in a drop down to set where each record item is located.

On the layout used to define locations, Id like a list of ALL items - water, food, utensils - that use that specific location record.

Not sure how to build a portal that looks at all three tables to see if it has the loc used and return it to the location layout for that record.

[comment]

Not sure how to build a portal that looks at all three tables

There is no such animal. Either use three portals or put all items (or at least their common fields) into a single table.

[Mark Reed]

im thinking I need to not use three tables and combine the food water and utensils into one table with a TYPE field and blend the unique fields on each into one table and only use the needed field on each layout... this would give me a one to one portal on locations

Would this be a better approach?

There is no such animal. Either use three portals or put all items (or at least their common fields) into a single table.

i was just typing that as you were hahah