Copying Records From another Table...

August 29, 200916 yr

Hello,

I don't know if I am putting this in the right sub-forum, but I am stuck again in my first FileMAker Development.

Ok, so this is how it goes:

1. I have two tables Header and Detail (one is to many). For each Header::Type, there are several Detail::Accounts and Detail::Percentages

2. In my transactions, I will create a table similar to the Detail Table, except for an additional field called "Value".

3. When my user enters a "Type" in my Transaction Header table, I intend to copy the related "Detail" records in #1 into a new table called Transaction Detail.

The problem is, I don't know how to copy related records from one table to another.

I would appreciate any help from you guys.

TIA

Danny

Manila, Philippines

August 29, 200916 yr

Hi,

you cannot copy "records".

You can copy or import field content from table to another table.

In any case - there are several possible solutions and befor to cheese one think about future project development.

August 29, 200916 yr

The words [color:blue]Lookup and [color:blue]Conditional Value Lists come to mind.

September 1, 200916 yr

Author

Hi LaRetta,

I know it's not a normal practice to "copy records from one table to another" but here is my application, in a nutshell.

I have a list of "Default Transactions", for example:

Cash Purchases

Credit Purchases

Borrowed Stock

Cash Sales

Cash Discounted Sales

etc.

And Each "Default Transaction" has its own list of "Accounting Entries". All these data will be supplied by the user (prefereably a CPA).

When a source document is created, the user selects which type of "Transaction" This falls under. So when he selects a "Transaction Type", I want my application to "copy" the Accounting Entries in the "Default Transaction" details, so that the user can modify the list, if he wishes to. This way, he can add or delete from the original list. Also, these "target" records will contain an additional field not found in the "source" table, whis is where the computation is done.

I hope I made sense...