Hoping someone can help me with this. I would like to see how to join/display table info via a couple of fields from multiple tables. Short version is I need the Table Bgen_name field to generate based on the matching model_id fields ..... IF the Table Amodel_year is between the gen_start_year and gen_end_year.
example: IF (model_year >= gen_start_year & <= gen_end_year, display gen_name)
I'm assuming that this process would be best performed in the load editor and I would appreciate seeing what that may look like. I'm still a little unsure where to put additional scripts in the editor so if you could show what the entire script (tables & all) looks like, that would really help me out.