Copying Records From another Table...

[rdal]

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

[Peter (duksis3)]

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.

[Lee Smith]

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

[rdal]

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...

Thanks again in Advance for the help. I am still stuck...

Danny

Manila

[rdal]

Can somebody please tell me EXACTLY what to do (step-by-step)? I am really stuck on this one...

Thanks In advance...

[rdal]

Gee Thanks LaRetta,

I will try to send the FP7 file as soon as I can...