I'm trying to create a database with FMP from an Excel sheet.
we use this excel sheet for storing our Wire Numbers with their location and other info as it shows.
I can import it with no issue.
My problem is I want to create a layout to input a new record but the wire number has to start with a specific letter (A, V, DV, DA, RF, TC, I, C, D). so If I create a new record I want to create the next available number with the correct letter in the begining.
Do I need to create different tables for each Wire Letter? and then make a relationship with the two tables?