How can I achieve this in Filemaker?

[noneofyo]

Hello Everyone,

I am new to Filemaker. Its been more than 24hrs now I have been trying to get this but no luck.

Please help me to achieve this.

I have two table product(id,productname,rate) and invoice(id,name,date,total).

I have layout for product, its working fine.

In the invoice layout including the fields from invoice table i want there to be also option to chose products from product table, in a tabular manner(similar to the product list on invoice layout on starter solution invoice), when clicked on productname i want a dropdown list to appear with the products from product table and in next column after product there will be a text box to fill in quantity and next to it will be total which will be the product quantity multiplied by product rate(to be looked from product table based on product selected). Finally I want the total field of invoice table to have the sum of all total from the product selected. How do i do this? Do i need pannel or something else.

Please help me and ask me if any clarification is required.

[Lee Smith]

Automatic message

This topic has been moved from "The Presentation Layer → Advanced & Developer Features" to "Database Schema & Business Logic → Value Lists".

[comment]

How do i do this? Do i need pannel or something else.

If I understand your question correctly, you need a third table for the invoice line items. See an example here:

http://fmforums.com/forum/showpost.php?post/309136/

[noneofyo]

If I understand your question correctly, you need a third table for the invoice line items. See an example here:

http://fmforums.com/...hp?post/309136/

Thanks Comment.

[noneofyo]

If I understand your question correctly, you need a third table for the invoice line items. See an example here:

http://fmforums.com/...hp?post/309136/

In the above example, how did you got the name of the product to display on the pannel on selecting the productID.

Thanks.

[comment]

By placing the field from Products on the layout. Note that the field is "merged" in order to prevent accidental editing.

http://www.filemaker.com/11help/html/create_layout.9.24.html#1028554

[adyf]

By placing the field from Products on the layout. Note that the field is "merged" in order to prevent accidental editing.

http://www.filemaker...24.html#1028554

Not to hijack the thread but I guess this is the reason why some fields on database samples that you have created display the field contents rather than the field name when in layout mode? Wondered how this was done, or is this something different?

[comment]

why some fields on database samples that you have created display the field contents rather than the field name when in layout mode?

No connection whatsoever: I have View > Show > Sample Data turned on as default.

[adyf]

No connection whatsoever: I have View > Show > Sample Data turned on as default.

Thanks for the clarification.