Hi Community, I am totally new to this with less then 48hours.
I am trying to create an APP that allows you to find the vehicle battery for your car and then give you details of that battery.
I have 2 main sheets :
- a battery table that lists the Battery_Model and then then all the other info (weight, size, plates, amp hours, etc…)
- a vehicle sheet that has vehicle_make, vehicle_model, Battery_Model
I want the user to tell me their make and model of vehicle, so I can then tell them the Battery_Model. I understand I can create a relation column on Battery_Model, BUT, how to select the row in the vehicle sheet based on 2 column search criteria/parameters ?