Create new record, copy data from table

[IplayWoW]

Situation: I'm trying to make a series of price summary "templates" in one table and it it to: create a new record, apply a serial number, and copy the desired data to a new record. From this record, a price summary will be made for a prospective customer.

I'm trying to make a script using the Create Record function but cannot get it to make the new record in the other table.

The template table holds non-modifiable fields. The data table holds the modifiable fields (to change Client name, tax, shipping costs, etc).

The field names in the Template table are the same as the field names in the Data table with the exception of _data being added to the Data Table fields

http://img68898.pictiger.com/images/16286565/

Sorry for my handwriting... I was in a rush.

Also, keep in mind I'm a newb. Thanks for the help

[Søren Dyhr]

IMHO is directly wrong to copy data anywhere, and especially if the task is to produce a summary report, this is unfortunately an attempt to remedy an inadequate relational structure. The Item lines should reside in a different table, as records ... not as data found neither in a splay across individual fields nor repeating fields.

The correct way is to do it this way:

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000717

You can of course be excused for making this ...blunder, because you might even have used one of the default template showing up when opening the tool.

These things occur ever so often because Filemaker Inc's strategy is to make a tool that takes over when you outgrow spreadsheets ...where macros often are found in severe ushering task, however does this violate relational theory - which filemaker also are made to abide to, to some extend at least.

--sd

[IplayWoW]

I think you're right and yes, it does make much more sense than what I had planned in my head.

Thankyou very much. I appreciate your time and help.

Chris