I need to have a second child record automatically added when the first child record is added.

Let me explain a little more.

I have an invoice table and invoice line items table in the same FMP File. The line items has a lookup to the Parts table in another FMP File. In the Parts table, there are two fields that I am working with, the "part number" and a "core part number".

When a user adds a "part number" to the invoice line items (via portal), if there is a value in the "core part number" field, I would like that to be added to a new line item automatically.

Any ideas on how I could do this?

Thanks

Shawn

Sounds like you need to run a script. One of the cool new features of FM10 is event triggering. Maybe you could run a script when the part number field is entered that checks the "core part number" field and adds if necessary.

You need a corepartnumber field in the line items table that is set to lookup when part number in line items matches part number in parts. No script necessary.

You'd do the same for price, in any invoicing solution.

Yes, I do need a second line item.

A "core" in this case, is a product that is rebuilt. Some people send us their "core" in advance and their product is rebuilt. Other people want to send in their old product AFTER we send them the rebuilt product, so there is a refundable charge that is applied, a "Core Charge".

Not all the client machines are on FMP v10. I was hoping there might be another way to do it..

Shawn

Interesting, LaRetta, good catch. This isn't something I've seen.