AnsweredAssumed Answered

Rental Shop : Multiple Relationship Diagram

Question asked by Handri on Nov 12, 2015

Hi Everyone,

 

My Name is Handri, I am new to Filemaker Pro. I followed the tutorial on Lynda.com by Chris Ippolite. And I have some question here.

 

I decided to make a solution for a Rental Shop, which the shop have their own products and the products from the supplier (may have many products), which every end of the month the shop has to make a report for the supplier every items which was rented.

 

So this is the table and relationship which I planned.

1. Customer

2. Invoices
3. Invoice Data

4. Products

5. Suppliers

6. Payments

7. Payments Data

 

Screenshot (1).png

 

Customer ----->Invoices ---->InvoiceData---->Products

 

Suppliers----> Payments---->PaymentData---->Products

 

=========================================================================================================

 

First Question :

I want to have a relationship between Products and Suppliers, to make the report of each item appears on Invoices, so the Rental Shop can make a payment to the Suppliers.

 

How can I make the relationship between Products and Suppliers ? Do I need the Third table to connect them ?

 

=========================================================================================================

 

About the Invoices.

 

As it is a Rental Shop, the payment has 4 parameters depending on the Return time. Each items have 3 rental days.

1. same day has 50% discount.

2. 2 nights over has 30% discount.

3. 3 nights has 0% discount.

4. overtime, 1 day have to pay extra 10% of the Item price.

 

Each item in one Invoices might not be return on the same time. Which this will effects the Payments to the Suppliers.

 

==========================================================================================================

Second Question :

 

Is it possible to make this kind of data ?
How ?

 

==========================================================================================================

 

 

About the Products.

 

The products has a Margin Rate for the Suppliers, each products has different Margin Rate. Which at the end of the month the Rental Shop have a report to each and all items of the suppliers. The reports includes the item which has a discount or extra payment from the customers.
And I wanted to have the Status of the Products which is (Rented or Available)

 

 

 

==========================================================================================================

Third Question :

 

Is it possible to make this kind of data ?
How ?

 

How to make the toggle for the Rented or Available according the data from the Invoices (if its Rented) ?

==========================================================================================================

 

I will attach my table's relationship, and please advice if I made a mistake.

 

Please kindly advice or help, even it is just a theory.
I will really appreciate it very much. And after I learned a lot from here, I want to share my knowledge and experience to help another people who needed a help as well.

 

 

Regards,

 

 

Handri

Outcomes