copy from a related table to other related table

[Mustafa55]

I have 2 related tables.one of them is B,the other is C, There is a Button in B table, When I click the button, I want the texts in fields to copy to related table C.

[LaRetta]

Hi Mustafa,

There is rarely the need to copy data from one table to another (particularly when they are related). If properly structured, you should be able to copy only the IDs from one table to the other.

But we really cannot make suggestions without understanding the relationships ... please use real table names when posting so we can understand the context. What are the real table names? And what is the table name of the layout where these portals reside? How are the three tables related? :-)

LaRetta

ADDED: In this example, you would copy table C's ID to table B so you know its source. And you would copy table C's parent ID (the one this layout is based upon) into table B as well. But this is all speculation at this point.

[imoree]

BUt Laretta, i use a Utility table to copy data for my specific needs. I think every situation is definately unique.

-ian

[Søren Dyhr]

Utility tables are even more impossible structurally speaking, there is no need for transfer more than one or two set of fields from one table to another ... a possible scenario could be what usually in filemaker is known as BOM:

http://forums.filema...osts/546709f6c0

Which deals with assemblies of parts being yet another ItemID in the same table ... in other words a recursive table structure, perhaps you should investigate this:

http://www.spf-15.com/fmExamples/BilloM.pf7

--sd

[LaRetta]

Hello there, Søren !!! Nice to see you drop in on us! You've been missed!

Ian, except for very rare developer need, data should not be copied about - only IDs as I suggested. This is the principle behind (and power of) relational. Of course every situation is unique but we do not have all information about an OP's solution to give perfect advice ... we must advise based upon probability and error on the side of safety.