Not sure how to ask this...

#1

When I am creating an invoice I have ten fields for things such as
quantity, rate, description, total, name id....

Is there possibly a way that I could have only one field for each of
those headings and just have rows create themseleves?

A tad confused.../*

Erik

#2

In article <slrnd8kjvq.1gd.t-use (AT) ID-685 (DOT) user.individual.de>, t-
use (AT) gmx (DOT) net says...

Quote:

On 17 May 2005 12:54:01 -0700, daload wrote:
Is there possibly a way that I could have only one field for each of
those headings and just have rows create themseleves?

A little bit weired - but you could use e.g. a layout A which holds a
portal to B. You may abuse this portal for your ten fields and go from
field 10 via tab to field 1 of the next row which automatically will
create a new record in B after you entered data.

You'll need a dummy relation, such as from A:

ne (which holds the value
1) to a field B:

ne with the permission to create new records as
needed.

Not the standard thing to do - users should create new records manually,
either by cmd-n or by the a button. But maybe you prefer the auto
creation...

Most people just have two tables... an invoices, and a lineitems. Then
put a portal on the invoices layout to its line items.

#3

A portal eh?

I will look into that!

Thanks,

Erik

#4

In article <1116368293.088034.268030 (AT) g43g2000cwa (DOT) googlegroups.com>,
"daload" <daload (AT) gmail (DOT) com> wrote:

Quote:

A portal eh?

I will look into that!

Thanks,

Erik

There are some standard Filemaker templates that use just this approcah,
of separate tables for invoices and line items, with the relationship
based on invoice ID, and a portal in the Invoice layout for the line
items. The relataionship has to be defiend to allow creation of line
items from the Invoice table.

It is also a good idea to have a table of inventory items with prices
etc that you can call up via a value list to put in the the line items
entries.

Bill

--
For email, remove invalid.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Not sure how to ask this...

comp.databases.filemaker comp.databases.filemaker

Not sure how to ask this... - 05-17-2005 , 02:54 PM

Re: Not sure how to ask this... - 05-17-2005 , 03:42 PM

Re: Not sure how to ask this... - 05-17-2005 , 05:18 PM

Re: Not sure how to ask this... - 05-17-2005 , 11:22 PM