Solved

product list in portal field

Posted on 2006-11-07
2
196 Views
Last Modified: 2010-04-27
i have three tables, customer, product and invoice.

i want to make a product list on an invoice layout.

and i want to make a product disappear on the list after purchasing.

do you know how to do that?
0
Comment
Question by:Hiroyuki Tamura
2 Comments
 
LVL 6

Accepted Solution

by:
JoJohn2004 earned 125 total points
ID: 17894083
To do this you want to connect a table occurance of products to invoices on product ID with a relationship where the Invoice::prodID  is not equal to the Product::product ID. The trick is to enter something (anything) in the Invoices::ProductID field. as long as the data does not match anything in the products table, all the products will show. once a product is entered all the other ones will show.

On another note, usually an invoice has a related invoice items table so that you can enter multiple items. You did not mention anything like this so I did not take that into account.
0
 

Author Comment

by:Hiroyuki Tamura
ID: 18082744
thank you
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
conditions for filemaker pro 10 if statement. 5 61
Airport Extreme 802.11ac 15 85
How to clone database on FileMaker server 11 2 172
Simple Search Script in FileMaker 4 72
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question