Hello,
I’m using a reference table that contains Bios/Descriptions. The table references an ID field in my primary dataset. The primary data set stores first and last names in separate fields, and I combined these with a hook to create a ‘fullname’ field. All of this works fine.
However, I can’t use my calculated field in the reference table, how do I accomplish this?
Hi,
I’m not sure that I fully understand the use case. Can you please send us screenshots and the site URL so that we can have a look?
Thanks,
Tal.
I want to accomplish what amounts to an inner join. But in addition, I want to concatenate two fields in the primary table and for display in the reference table. e.g. Table 1 (Reference) columns = MID, Description. Table 2 (Primary) columns = ID, Last Name, First Name.
I want to Join Table 1 to Table 2 where MID = ID. In addition I want the fields Last Name and First Name to be combined into a new field called ‘fullName’. I want to be able to assign fullname to text box ‘text’ properties.
Hi,
I’m also not fully understand the use case. screenshots will be helpful in order to help you.
Roi
I explained it above in detail. Joins are a pretty common database task. You don’t need screen shots. Anyways, forget it. All the best.