Chris,
why make it so complicated. You don't need any record coping. All the
portal rows are coming from the same table, right?
Then build you report on that table.
Make relationship from your daily transaction tbl to the main table
you are using (where your portals are, for getting the main fields in
the report.
Search for that day, sub summarize it by departments and you have
your report.
You can search for that day and one department and build report for
only that department.
That script can be run from your main table (so you'll never need to
leave it).
Your frequent FM talker:
Pavle Ancevski Pajo
New York Hotel Trades Council
[hidden email]
On Jun 25, 2009, at 10:46 AM, Chris Botticella wrote:
> I want to accomplish an End of Day Report showing all transitions
> which I do now and create an "invoice" system for each department.
> If I can pick and choose (copy record entries) the various
> departments from the Daily Entry of items which are chronologically
> entered and paste these same records into an Invoice layout I can
> then send these to each department head to show transactions for
> that department. So my Daily Report would have 10 entries...3 from
> dept 1, 2 from dept 3 and 5 from department 3. I would print three
> Transaction Reports at the end of the day.
>
> Any clearer?
>
> Thanks
> Chris
> ----- Original Message ----- From: "Salman Maidan"
> <
[hidden email]>
> To: <
[hidden email]>
> Sent: Thursday, June 25, 2009 10:36 AM
> Subject: Re: Portal Rows
>
>
>> Hello,
>>
>> It all depends on the reason for the copy and paste. what are your
>> objectives? what are you trying to achieve?
>>
>> Salman
>> On Thu, Jun 25, 2009 at 5:12 PM, Chris Botticella <
>>
[hidden email]> wrote:
>>
>>> I am using FMP 9 Advanced on Windows XP
>>> I have a portal that records various daily line items from different
>>> departments
>>> Each item from each department is recorded each day
>>> At the end of the day there may be 3 line items from one
>>> department 2 from
>>> another etc.
>>> What I would like to do is copy each portal row and then paste it
>>> into a
>>> transaction record
>>> So I would go into row 1 repairs, copy and paste into a Repairs
>>> Transaction
>>> record
>>> go into row 3 repairs, copy and paste into the same Repairs
>>> Transaction
>>> record
>>> go into row 7 repairs, copy and paste into the same Repairs
>>> Transaction
>>> record
>>> At the end of the day I would have Repairs Transaction record
>>> with 3 items
>>> (records)
>>> I would have another Sales Transaction record with 5 items etc.
>>>
>>> I tried to go to a portal row select all copy and try to paste
>>> it in the
>>> Transaction Record but it only copies and pastes the first field.
>>>
>>> Is this possible? To copy a portal row (an entire record) and
>>> paste it
>>> into another layout (separate table) to control its own set of
>>> records?
>>>
>>> I hope I am clear
>>>
>>> Any suggestions would be greatly appreciated.
>>>
>>>
>> _______________________________________________
>> FMPexperts mailing list
>>
[hidden email]
>>
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au>
>
> ----------------------------------------------------------------------
> ----------
>
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.5.375 / Virus Database: 270.12.91/2201 - Release Date:
> 06/25/09 06:22:00
>
> _______________________________________________
> FMPexperts mailing list
>
[hidden email]
>
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
