Nuri Baba Posted February 1, 2015 Share Posted February 1, 2015 I apologize for my bad English. I've written a few times on this forum but I could not get a result. The staff of the company I work from home, I plan to move the database to work from home business. Where the job description as follows: TABLE: CUSTOMERS BUSES DRIVERS ROUTES INVOICES FATURA_LINES PAYMENTS Buses with the specific route, picked up from the office staff to the office in the evening customers are left home away from home in the morning. Pricing is done by time. Every day time are the same. Each customer is different, there are different routes and prices. Each customer is done with 1-year contract. Billing is done monthly bill payments cut Getting Cash or Cheque. How do I establish a relationship where my problem and I need to start from. Do me a rough draft yapabilirmisiniz file on this matter. Moderate use my little knowledge I var.filemak 13 version. Thank you in advance for your help. Link to comment Share on other sites More sharing options...
Wim Decorte Posted February 2, 2015 Share Posted February 2, 2015 How do I establish a relationship where my problem and I need to start from. You have not stated what your problem is. You have outlined some of what the solution should do but not where you are stuck. Link to comment Share on other sites More sharing options...
Nuri Baba Posted February 2, 2015 Author Share Posted February 2, 2015 Wim Decorte;  VerdiÄiniz cevap için teÅekkür ederiz  Complex Many-to-Many Relationships  BUS SÃRÃCÃLER masa ve nasıl iliÅki?  Ben örnek dosyayı baÅlamak istiyorum.  Bu sorun,  TeÅekkür Ederim Link to comment Share on other sites More sharing options...
Steve Martino Posted February 2, 2015 Share Posted February 2, 2015 C'mon Wim, that last post should clear things up Link to comment Share on other sites More sharing options...
Lee Smith Posted February 2, 2015 Share Posted February 2, 2015 What’s the matter Steve, don’t speak Bocce? LOL Link to comment Share on other sites More sharing options...
Steve Martino Posted February 3, 2015 Share Posted February 3, 2015 @Lee...I never even heard of Bocce. I was more confused when I tried to let Bing translate it. :) Link to comment Share on other sites More sharing options...
Lee Smith Posted February 3, 2015 Share Posted February 3, 2015 Sorry Steve, it was a joke. I forgot it was an Italian bowling game, my reference was to Star Wars. Because nuri posted what looked like his/her fingers had slide off of a keyboard row. Anyway, the Bocce I was referring to is a Star Wars language, here Bocce and here Wikipedia , Lee Link to comment Share on other sites More sharing options...
LaRetta Posted February 3, 2015 Share Posted February 3, 2015 I believe that the umlaut suggests it is a foreign language.  Google Translate implies it is Turkish: Thank you for your response  Complex Many-to-Many Relationships  BUS DRIVERS table and how the relationship?  I want to start a sample file.  This problem Thank you Hi Nuri,  If I understand you (and that is a big IF), you want to know how to relate the Drivers and Buses?  Routes would be your Product, placed on Invoice Lines each time a Route is 'sold.'.  Your Driver and Bus are what is required because a Route can not happen unless it has both a Driver and a Bus.  The relationships would (probably) best be expressed as the attached example.  Please continue to ask questions and we will be happy to work through the translation so we can help you.  :-) Link to comment Share on other sites More sharing options...
Nuri Baba Posted February 3, 2015 Author Share Posted February 3, 2015 Dear LaRetta ;  As you can imagine in your Staff want to build a database related to transportation.  As seen in the picture below ERD, I yöndemiy right to begin with?   Turkish:  Sizinde tahmin edeceÄiniz gibi Personel TaÅıma ile ilÄili bir veritabanı inÅa etmek istiyorum.  AÅaÄıda resimde ki ERD de görüldüÄü gibi, baÅlamak için doÄru yöndemiyim?    language:Türkçe Link to comment Share on other sites More sharing options...
LaRetta Posted February 3, 2015 Share Posted February 3, 2015 As seen in the picture below ERD, I yöndemiy right to begin with? Hi Nuri, I can not translate the world 'yöndemiy' but your ERD appears correct. Your Invoice_Line table would then have an fk_assignmentID field and when the route has been travelled and the Assignment is complete, the Company is billed by creating an Invoice_Line record with this kp_assignmentID. The Invoice_Line price could be a lookup from the Assignments extended price. If Assignments can never change once completed, you could instead just reference the related Assignment price which will be available through the relationship as soon as you insert the kp_assignmentID into the Invoice_Line record. ERD to connect these tables: Invoice_Lines::_kf_assignmentID = Assignments::__kp_assignmentID en içten dileklerimle Link to comment Share on other sites More sharing options...
Nuri Baba Posted February 3, 2015 Author Share Posted February 3, 2015 Dear LaRetta; Â Will be my case. Â If not you sample an ERD. Â Thank You Link to comment Share on other sites More sharing options...
LaRetta Posted February 3, 2015 Share Posted February 3, 2015 The only change I would make is to place your Invoices table between Company and Invoice_Lines, with the Invoice itself holding the _kf_company_ID (assuming an Invoice can only belong to a single Company). Most times, it also helps to have the _kf_company_ID in Invoice_lines so you can leave it there, but it can be an auto-enter or lookup from the invoice itself. You have a pretty clear understanding of the necessary structure. :-) Link to comment Share on other sites More sharing options...
Nuri Baba Posted February 4, 2015 Author Share Posted February 4, 2015 hi LaRetta ;    Anchor Buoy  My new ERD,Have you got anything to add / any suggestions?  En içten dileklerimle  Nuri Link to comment Share on other sites More sharing options...
Lee Smith Posted February 4, 2015 Share Posted February 4, 2015 That is a Relationship Graph, not an ERD, they are different. Link to comment Share on other sites More sharing options...
Nuri Baba Posted February 4, 2015 Author Share Posted February 4, 2015 That is a Relationship Graph, not an ERD, they are different. Could you explain it further? Link to comment Share on other sites More sharing options...
LaRetta Posted February 5, 2015 Share Posted February 5, 2015 I thought you had what you needed, Nuri ... confirmation that your structure was correct. If not, then we are back to Wim's question ... What is it that is still a confusion? There is no need for me to give you a file with this structure when, according to your relational graph, it is all there. I know language issues can make this a bit difficult but please try to say more of what you need, okay? :-) Link to comment Share on other sites More sharing options...
Nuri Baba Posted February 5, 2015 Author Share Posted February 5, 2015 I thought you had what you needed, Nuri ... confirmation that your structure was correct. If not, then we are back to Wim's question ... What is it that is still a confusion? There is no need for me to give you a file with this structure when, according to your relational graph, it is all there. I know language issues can make this a bit difficult but please try to say more of what you need, okay? :-) It seems to me that we had better Can you give examples of the demo file. It was a pleasure to discuss you these points. Link to comment Share on other sites More sharing options...
LaRetta Posted February 5, 2015 Share Posted February 5, 2015 If I gave you a demo file, it would be exactly what you have. That is precisely how *I* would approach your problem. Others may have other suggestions. If you want me to add all the scripts and buttons and layouts for it then, no ... I cannot take the solution that far. If you begin to build onto this file and you get stuck, post a specific question and we can help you through it. Does that sound okay? Link to comment Share on other sites More sharing options...
Nuri Baba Posted February 5, 2015 Author Share Posted February 5, 2015 It seems to me that we had better Can you give examples of the demo file. It was a pleasure to discuss you these points. I think I should clarify what I said Relational graph, ok? I’ll let you know if there is any problem. I suppose we have a deal, then. En içten dileklerimle Link to comment Share on other sites More sharing options...
LaRetta Posted February 5, 2015 Share Posted February 5, 2015 Well I do not make deals nor take bets! And I said 'we' can help you through it, here on forums. But I will always try to help if I can AND if I have the time, you can depend upon that. Ben size tasarımı ile diliyoruz . (I wish you the best with your design) Link to comment Share on other sites More sharing options...
Nuri Baba Posted February 5, 2015 Author Share Posted February 5, 2015 If I gave you a demo file, it would be exactly what you have. That is precisely how *I* would approach your problem. Others may have other suggestions. If you want me to add all the scripts and buttons and layouts for it then, no ... I cannot take the solution that far. If you begin to build onto this file and you get stuck, post a specific question and we can help you through it. Does that sound okay? Great! Then we’ve got the deal. I am sure this is a rare problem Language problem Link to comment Share on other sites More sharing options...
Lee Smith Posted February 5, 2015 Share Posted February 5, 2015 Could you explain it further? No. However, you can find the answer by searching the web for difference between ERD and Relationship Graph. Link to comment Share on other sites More sharing options...
Nuri Baba Posted February 5, 2015 Author Share Posted February 5, 2015 No. However, you can find the answer by searching the web for difference between ERD and Relationship Graph. Lee; Thank You Link to comment Share on other sites More sharing options...
Mark Scott Posted February 5, 2015 Share Posted February 5, 2015 Off topic: Cool avatar, Nuri. I am sure this is a rare problem Language problem Yes, language differences do occasionally impede clear communication here on the forum—the most prolific responders being primarily English-speaking—but usually things get answered in the end. Kudos to LaRetta for going the extra mile and using Google Translate to translate your Turkish description of the problem. Link to comment Share on other sites More sharing options...
Nuri Baba Posted February 5, 2015 Author Share Posted February 5, 2015 Off topic: Cool avatar, Nuri. Yes, language differences do occasionally impede clear communication here on the forum—the most prolific responders being primarily English-speaking—but usually things get answered in the end. Kudos to LaRetta for going the extra mile and using Google Translate to translate your Turkish description of the problem. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3367 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 accountSign in
Already have an account? Sign in here.
Sign In Now