FMP and Excel

Discussion created by dasaint80 on Jan 21, 2019
Latest reply on Jan 21, 2019 by comment

Hello All,

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?