0

Help with Structure

In my database I have:

  • Projects
    • Quotes
    • Bookings
    • Factory Orders

 

Each Project can have multiple Quotes, multiple Bookings, and multiple Factory Orders.

Each Booking must have only one Quote from its Project associated with it.

Each Factory Order must have only one Quote from its Project associated with it.

 

I could structure my links such that Projects have Quotes which may have a Booking and each Booking may have a Factory Order. But if I do this, how can I display all the Bookings and Factory Orders for a particular Project when the user views a Project record?

2 replies

null
    • Fred
    • 1 yr ago
    • Reported - view

    If Projects are related to Bookings and Factory Orders through Quotes then you can create view elements and put this in the formula section:

    Quotes.Bookings
    or
    Quotes.'Factory Order'
    
      • Kent_Signorini
      • 1 yr ago
      • Reported - view

      Fred Excellent! Thanks!

Content aside

  • 1 yr agoLast active
  • 2Replies
  • 45Views
  • 2 Following