Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

product list in portal field

Posted on 2006-11-07
2
Medium Priority
?
200 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Accepted Solution

by:
JoJohn2004 earned 500 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
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…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Suggested Courses

705 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