Jump to content

Showing Data From A Relationship's Related DB


RickGrundy

This topic is 7549 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I come from a SQL background and am used to being able create joins between multiple tables to get at the data I need. With FileMaker, I am limited to a one-to-one join and I would appreciate any ideas for how I can accomplish the following:

I have a Company DB that relates to an Invoice DB. The Invoice get LineItems from a LineItems DB that gets product information from a Product DB. On the Company DB Layout, I want to have a portal that shows all Products that the company has purchased (i.e. been invoiced for). Essentially, I need to find all Product ID's that related to that Company ID through an Invoice.

How can I do this? I already have a portal that shows Invoices, but I want to go one level further and show the individual products purchased from a Company layout. Is this possible? Am I making it more difficult than it really is?

Thanks for your help!

Link to comment
Share on other sites

  • 2 weeks later...

OK, I set up the fields and relationships following the Matrix Data Modelling method (thanks Fitch). I currently have a Portal on my Company DB that can list Products that have been listed on an invoice for the company. However, it only lists products that appear on the first invoice for that company.

I need to somehow get it to show all products from all invoices in a company. Is it possible to put a portal inside another portal? Or am I just crazy? Is there any way to display all products that have been listed on any invoice for a company?

Thanks again for your help.

Link to comment
Share on other sites

This topic is 7549 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.