Calculated Fields and Text Concatenation Possible?

[nycwebmaster]

Hello guys, I’m trying to make a calculated field that involves text instead of numbers. I would like to know if there is a way to do this:

I have a scenario in which I have a Table called Events.

I want to have a calculated field named Contractors_Attending that will list all the Contractors that we have assigned to attend to each event, this means that multiple Contractors can be assigned to one event. Below I’m explaining the name of each table and field, also the relationship between the tables.

Notes: The Contractor_Name on the Invoice is Retrieved from the Profile table. It is a combination of: First_Name and Last_Name

Here is the Tables and Fields:


Table Name: Event
Field Name: Company_Name
Field Name: Contractors_Attending





Table Name: Profile

Field Name: First_Name
Field Name: Last_Name

Table Name: Invoice

Field Name: Contractor_Name

Field Name: Company_Name

[xbox2007]

hello
what the key between this table .

in my project i use calculated field to Make invoice number :

for example if ID = 1000 ,
then invoice number will be RE-1000

Code: Select all

SELECT CONCAT('RE','-',%ID%) FROM `Item_Request`  WHERE  `Item_Request`.`ID`='%ID%'

[nycwebmaster]

thank you, but your situation does not apply here.