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
-
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'
Content aside
- 2 yrs agoLast active
- 2Replies
- 49Views
-
2
Following