I have a table and one of the columns is PO ...

(Shawn Strahan) #1

I have a table and one of the columns is PO #.

I’d like to make this an enum with the ability to add new POs to the list but to restrict the PO list by the customer.

This Valid IF formula is what i had in mind…

=SELECT(Current Billing[PO #],[Facility]=[_THISROW].[Facility])

but when i do this it removes the ability to add a new one.

Facility is NOT the column to the left of PO #. I’d prefer not to make another table to house the POs.

I already have too many tables.

Any ideas?

Id prefer not to make a new table to house this PO data.

Any Suggestions

(Shawn Strahan) #2

Current Billing table is the table that has the PO # in it.

FYI

(Aleksi Alkio) #3

The customer should probably have to have the ADDS access to this table, correct?

(Lina Osorio) #4

Yes.

Are you saying I have to add a PO sheet in order to do this?