Need Help with Form and show_if()

[ABBA]

Hi Friends

I have a a table and form from that table for input.

I have a ref table [Tank or Gauge Name] and I am using buttons to show them in the form. All the code is based on selection of the [Tank or Gauge Name]

When I click the selection a drop down of [Tank of Guage ID] drops

I dont want this to be dropdown but rather an auto SELECTTION process in the app, because each [Tank or Gauge Name] has a specific [Tank or Guage ID]

Also, since the code is based on [Tank or Gauge Name] or [_ThisRow], I have to have [Tank or Gauge Name] as selection, when the users prefer [Tank or Gauge ID]. 

is it possible to change something in the table where I dont have to change all the 25 to 30 formulas to [Tank or Gauge ID] but rather have users select [Tank or Gauge Name] and this action auto selects the corresponding [Tank or Gauge ID]?

I have a table [Tank Gauge List] that I am using as reference to get [Tank or Guage Name]-column Tank or Guage Name

ID	Facility	Tank or Gauge Name	Tank#	Type	Capacity	bbls/in
EARL Harlan-11978	EARL Harlan	11978	Production Tank	Oil	300	1.167
EAST Dome Ellis-25293	EAST Dome Ellis	25293	Production Tank	Oil	300	1.167
EAST Dome Ellis-66018	EAST Dome Ellis	66018	Sales Tank	Oil	300	1.167
MOSBY Dome Ellis-11955	MOSBY Dome Ellis	11955	Production Tank	Oil	300	1.167
MOSBY Dome Ellis-Sales Tank #1	MOSBY Dome Ellis	Sales Tank #1	Sales Tank	Oil	300	1.167
Unit#1-1230	Unit#1	1230	Production Tank	Oil	300	1.167
Unit#1-1231	Unit#1	1231	Production Tank	Oil	300	1.167
Unit#1-55769	Unit#1	55769	Production Tank	Oil	300	1.167
Unit#2-21469	Unit#2	21469	Production Tank	Oil	300	1.167

Also I have another table called [Tank Guage Capacity] from which I get [Tank or Guage Name] as Unique([Tank Guage Capacity].[Tank or Guage ID-Name])

I know the code is jumbled

I am trying to simpli