Re: Linking Fields & Autofill

And if you are trying to link to seperate field (getting sdeperate results)
you need separate TableOccurances. One for each unque field you are trying
to relate to. Obviously tou are getting the same result over and over agian
because you are using the same relation each time.

Ursus


"Grip" <grip@xxxxxxxxxxxxx> schreef in bericht
news:1173279287.210713.284260@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Again I don't know how your database is set up, but I'm guessing
you're using pre-built form that relies on repeating fields instead of
a separate table for line items. You need a third table, for line
items. If that's not the case, you need to explain your current
databse structure better.

G

On Mar 7, 12:48 am, "Jeff" <jeff.bo...@xxxxxxxxxxx> wrote:
That was what I am trying to do, and that part works but when I have
several
lines For items in the same form all lines duplicate each others results.

Item Price

Item Price

Item Price

When I Fill In the 1st they all come back with the same results, If I
change
the second They all change to match.

Thanks Jeff

"Grip" <g...@xxxxxxxxxxxxx> wrote in message

news:1173239549.803669.121150@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

On Mar 6, 6:54 pm, "Jeff" <jeff.bo...@xxxxxxxxxxx> wrote:
I have created a quote form for my business but am having trouble
getting
1
function to work.

I have a field called item and a field called price, quantity, total..

The math works fine but I would like to select the item from a drop
down
box
and have that selection

automatically fill in the price that goes with that item.

Right now I have to select the item and manually fill in the price,
This
is
getting old fast with 100's of items.

Any help would be greatly appreciated, I am sure it is something
simple,
I
was successful in access so I assume

it is achievable in FM

Thanks
Jeff

It's not clear how your database is already set up. How are you
selecting the item currently? It sounds like you're not typing it in
manually, so where does it come from? Is there another table which
stores the items?

If you were to start if from scratch, you would need to make another
table named Items with at least three fields: ItemName, ItemPrice, and
ItemID. Set ItemID to be an Auto-Enter serial number field, so each
ItemID is the unique identifying number for that item. Add an ItemID
field to your line items table or whatever table you're currently
entering the quantity in. Then you relate the Items table to the
LineItems table via that field. In the field definition for Price,
you can set an Auto-Enter Lookup, using the value from your related
Items table.

G




.

Relevant Pages

  • Re: Linking Fields & Autofill
    ... you're using pre-built form that relies on repeating fields instead of ... Item Price ... and have that selection ... Set ItemID to be an Auto-Enter serial number field, ...
    (comp.databases.filemaker)
  • Re: problem with subform
    ... for the control, make the DefaultValue --> 1 ... Name --> ItemID ... unit price (PROBLEM AREA, i have a field in my receipt which says 'unit ...
    (microsoft.public.access.forms)
  • Re: GROUP by, but not exact...
    ... > SELECT docid, itemid, SUMAS qty, price ... > LEFT JOIN TmpTbl AS T2 ...
    (microsoft.public.sqlserver.programming)
  • Re: GROUP by, but not exact...
    ... group by docId, itemId, price, priceId-cnt ... > docId, itemId, priceId form a primary key. ...
    (microsoft.public.sqlserver.programming)
  • Q: Query - Price on specified date for each item
    ... create table #itemprice ( ... ItemID int NOT NULL, ... PriceDate smalldatetime NOT NULL, ... Price money NOT NULL) ...
    (microsoft.public.sqlserver.programming)