Need some advice on how to best handle value lists

[Bfabes]

Let me explain what I am attempting and hopefully someone can provide advice as to the best solution.

I have 2 tables. Projects & Assets. Each project is made of multiple assets. When a single asset is entered into FM, it is given a Project name. This project name is created by choosing from 3 value lists I have created. The field names are:

1 - SerialID

2 - CategoryID

3 - ShortName

I need all three of those fields to create the ProjectName field.

How do I do this? How do I merge all three separate fields into one field called ProjectName?

Concatenation? Script?

Since the ProjectName field is the link between the Projects Table and Asset Table I need it created in both tables after the user has selected the values from the three value lists.

I am very new to FM and I apologize if I am asking a noob question. Thank you for your time and assistance.

[comment]

You can define the project name as a calculation field (result is Text ) =

SerialIncrement ( "000" ; SerialID ) & "_" & CategoryID & "_" & ShortName

However, you should use ONLY the SerialID field as the link between the Projects Table and Asset Table.