Hi,

I'm a real novice at filemaker however have used the invoice function
that is currently bundled to try and enter a job sheet. For each line
item entered, I have a corresponding linked record (saved in a
seperate table) that has a number of parts. I would like to create an
index of these records in the new table using the invoice number, data
from a field on the line being entered and a count on that line
combined. I'm not sure how to go about this.

For example I have invoice no. 1001326 - on this invoice I have as
line 1, product sales of 15 widgets of "stylex". line 2, product sales
of 3 widgets of "styley".

I would like to reference this record as 1001326-stylex-1, and the
next record as 1001326-styley-2.

Am not sure how to go about this?

Thanks

Phonse

Phonse,

just put the fields together using a calculation. Say you have fieldA and
fieldB.
Create a new field, set the type to calculation, set the result to text, set
the otions (the part where you define the calculation) to fieldA &
"-stylex-" & fieldB

Keep well, Ursus

<phonse (AT) spin (DOT) net.au> schreef in bericht
news:1172488447.162459.189630 (AT) z35g2000cwz (DOT) googlegroups.com...

On Feb 26, 10:39 pm, "Ursus" <ursus.k... (AT) wanadoo (DOT) nl> wrote:
Thanks for your reply Urus,

The system does not want to store the information in that format and
wants to recalculate each time. In addition is there a way to add the
line count for each line in the order?

thanks

Phonse

For not storing calculated results you do the same, then go to Storage
Options, select the option: Do not store calculation results. This results
in recalculating every time the field is used or accessed.

You can countthe number of line items by using the count function. see the
helpfile for exact use

Ursus

<phonse (AT) spin (DOT) net.au> schreef in bericht
news:1172682404.590209.131940 (AT) h3g2000cwc (DOT) googlegroups.com...

In article <45e5ce6b$0$52385$dbd43001 (AT) news (DOT) wanadoo.nl>, "Ursus"
<ursus.kirk (AT) wanadoo (DOT) nl> wrote:
<phonse (AT) spin (DOT) net.au> schreef in bericht
news:1172682404.590209.131940 (AT) h3g2000cwc (DOT) googlegroups.com...

That will return a count of ALL the related record lines for the
current record, but it won't give each related record it's own number
based on the order they were entered.
ie.
Record 1 Line = 1
Record 2 Line = 2
etc.

It depends a little on exactly why you want to add the line number (eg.
it's easier to add for a printout of just one invoice's line items),
but unfortauntely there isn't going to be an easy way to achieve this
and even more difficult to add to existing records.

For anything more than the simple single record line items printout,
you'll have to define a new Relationship in the line items Table that
uses the Invoice Number to group them together appropriately, then you
can have a field using an auto-enter calculation to "count" each line
item AS IT"S ADDED - so this will only work for records entered from
then on.

For existing records you'll have to create a script that uses this
above Relationship to loop through each Invoice's line items inserting
the line count.

As I said, not exactly easy if you are really a "novice" in FileMaker.
It's up to you whether it's actually worth doing, but since I don't
have the Template file you're using I don't know the structure of the
system to be more concise.


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)