solutions wanted can an ADD_LINE_ITEM portal be duplicated?

[pantidos]

hello,

In my invoice layout, i have an add line item for my products. The thing is that i want to make another add line item for my services and

this is where i have the problem.

i actually copied the way the first addline item works, by creating a new table, make the proper relationships, duplicating and change the script

( Sets

variable with INVOICE ID, Create new record, set INVOICE ID, and

return to original layout)

for the addlineitem button but still when i

press the button it says "this operation cannot be completed because the target is not part of a related table".

, is it a problem that i use the invoice id again in the script?? i think there is a problem with the primary key cause is the same in both tables( T1_add_line_items , T2_add_line_items )

How can i put these two portals works independently? i need to do this, for the print view..

any suggestions???

[pantidos]

hello,

as you can see in the picture i have an add line item for my products. The thing is that i want to make another add line item for my services and

this is where i have the problem.

i actually copied the way the first addline item works, by creating a new table, make the proper relationships, duplicating and change the script

( Sets

variable with INVOICE ID, Create new record, set INVOICE ID, and

return to original layout)according the new table etc for the addlineitem button, but still when i

press the add button it says "this operation cannot be completed because the target is not part of a related table".

Is it a problem that i use the estimate id again in the script and in the new table ?? i think there might be a problem with the primary key cause is the same in both tables( T1_add_line_items , T2_add_line_items )

How can i put these two portals works independently? i need to do this, for the print view..

any suggestions???

[bcooney]

Please do not double post. I've merged your two posts.

I see that you are working with one of the templates that FMI provides.

Product and Service line items should really be in the same table, with a type field indicator. If you don't do this, you will run into difficulty trying to report on your sales (pulling from two tables for a report involves complicated techniques).