Copy Field contents from one Table to another table - FileMaker

Granadian Published at Dev

Granadian

I am new to Filemaker pro. I am working with Filemaker pro 13.

My database contains 3 tables:

category (fields = _pkCatID & CatName)
subcategory (fields = _pkSubcatID , _fkCatID & SubcatName)
books (many fields including _fkSubcatID)

I have no problems in conditional value lists, so making two popup menus in books layout for categories and subcategories was successful.

But I want to put both categories and subcategories in one menu/sub-menu using 2empowerfm Menu Popper plugin.

I created a new field in subcategory table to store a calculation to be used in the value list of the plugin. The calculation is = CatName & ">" & SubcatName & ";" & _pkSubcatID . So the returned value when choosing in books layout will be "_pkSubcatID".

The problem is CatName is not in Subcategory table, and if I choose it from the related table Category, I can't make the calculation "stored" which is a requirement to use a field in a value list.

So, I need to copy the field CatName from category table to a new created field in subcategory table. I don't know how to do it.

Michael Wallace

You just need to create a lookup field in your subcat table pointed to the category name in the category table.

Create a field in the sub-cat table called "Category"
Click on Options
Auto-Enter Tab at the bottom, check "Looked-up value"
Select the correct starting (subcat) and related (Cat) tables and select the name field for the Category.

That is all.

To populate this for existing records click into the _fkCatID field on a subcat layout after showing all records and in the menus select Records->Relookup Field Contents

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-02-14

Comments

0 comments

From Dev

Related Related

Article

Copy Field contents from one Table to another table - FileMaker

Copy Field contents from one Table to another table - FileMaker

MYSQL Copy field from one table to another table

FileMaker - Getting Data From Another Table with Multiple Field Restrictions

Copy Contents of One Column Of a Table To another of a different Table SQL

Copy Data from one table to another table

copy data from one table to another table in another database

Copy table data from one database to another

Copy Data from one hbase table to another

SQL to copy values from one table to another

Copy table from one database to another database

How to copy rows from one table to another?

Copy a row from one table to another

Copy Data from one hbase table to another

Copy table data from one database to another

Jquery - copy a row from one table to another

Copy contents of one field to another using jQuery

Can you copy table privileges from one table to another in postgresql?

How do i copy data from one table to another table?

MYSQL, copy data from one table to another table with increment in varchar

Mysql Trigger, Copy All Rows From One Table Into Another Table

Copy from one temp table to another temp table on condition base?

How do i copy data from one table to another table?

Using a composite key from one table in a field in another table

Using values from a field in one table as column name for field in another

copy one table to another in cassandra

copy one table to another in cassandra

Copy from one table to another and replace with SCOPE_IDENTITY

Can I copy from one table to another in Redshift

How copy data from one table into another? PHP

How to copy data from one table into another in Microsoft SQL Server