Re: Linking Fields & Autofill

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
    ... lines For items in the same form all lines duplicate each others results. ... Item Price ... and have that selection ... Set ItemID to be an Auto-Enter serial number field, ...
    (comp.databases.filemaker)
  • Re: Linking Fields & Autofill
    ... 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 ... Set ItemID to be an Auto-Enter serial number field, ...
    (comp.databases.filemaker)
  • Re: Linking Fields & Autofill
    ... you need separate TableOccurances. ... Item Price ... 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)