Title
Pulling Information
Post
I want to certain information from a certain field in 1 layout to another layout in a certain field. What kind of script would i need for that
Pulling Information
I want to certain information from a certain field in 1 layout to another layout in a certain field. What kind of script would i need for that
"Well [They're] both related by invoice number and line items"
Sorry but that's just a bit vague. Exactly how are they related? (What fields in one table match to fields in the other?)
Does a record in the category discount table compute the discount? A flat fee discount? A percentage? Is it computed based on total sales for the current invoice?
I think you have at least three tables involved here but could be wrong:
Invoices--<LineItems>--CategoryDiscounts
Ok i mean the things that both layouts share is
ID_invoice
Category
Subtotals
Order totals
ID_invoice---<Lineitems>---- Category discounts
Both are linked with the ID_invoice the discount layout is category summary that gives me the subtotals for each category then i have a discount lin that discounts from that subtotal. at teh trailing grand summary i have a total discount box which is a summary field that totals the discounts for all the category. now what i want to do is pull that number into my invoice page so i can use it to minus the grand total and get my new grand total
Still not totally clear here.
Are these the relationships that you have?
Invoices::InvoiceID = LineItems::InvoiceID
CategoryDiscounts::InvoiceID = LineItems::InvoiceID AND
CategoryDiscounts::Category = LineItems::Category.
I've deliberately not talked in terms of layouts as that's yet another detail that can't be dealt with until I understand the specific details of how you've linked your tables.
Filemaker Set Field Command
http://www.filemaker.com/help/html/scripts_ref1.36.40.html