Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Greg58

  • Rank

FileMaker Experience

  • Skill Level
  • FM Application
    16 Client

Platform Environment

  • OS Platform

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Thanks for the reply. The DB is for my use only and not for a number of shareholders. I started by thinking that I needed a join table between companies and transactions because each company can be bought and sold many times, and a transaction can apply to many companies. companies >> join << transactions Would this be right?? Thanks.
  2. I want to design a database to record the purchase and sale of shares including dividends. I can't even get past stage 1!!! In my mind I would have a company table, a holdings table, and a transactions table. But I cannot figure out how to wire this up?? I have attached my attempt. Can anyone please give me a kick start?? Thanks. Trades 210223 Copy.fmp12
  3. Just wondering if you can explain how the portals are set up please? Can't get them to work. I have attached a pic of my setup. Thanks.
  4. Great. Thanks for the explanation 😀
  5. Can I jump in here and ask which keys are the primary keys for the advisors and students in Wim's solution please?
  6. I have a client layout which displays one client per page. Each client has several phone numbers (home, work, mobile). I created a separate table for phone numbers (one to many) connected by the clientID. The phone table has ID, clientFK, type (mobile, home, work), and number. I created a portal on the client page to display the various numbers for each client. It works ok. I then created a Client list. Can I display a specific number from the phone list on the portal?? Thanks for any assistance.
  7. Sorry but still having a problem with this. I have tried several methods to remove the employee from the portal but not delete the child record, but having no success. Would you mind having a look at the example file please?? CompanyEmployee.fmp12
  8. Thanks Comment. That clears this up for me.
  9. I have tried to find the answer to this but cannot. I have a HOUSE Table (parent) and an OCCUPANT Table (child). I have a portal on the HOUSE layout showing the occupants for a particular house. When I delete the occupant, it also deletes the occupants record!! I do not have the delete box checked in the edit relationship dialogue box. I have attached the file. Thanks for any assistance. HouseOccupantExampleForumQ.fmp12
  10. I have a 'Jobs To Do' file. In it I create a job and assign it to people who are listed in a portal. I have a dwindling VL on the portal which ensures the same person cannot be assigned to the same job twice. What I am trying to do is to ensure a person is only assigned to one job. ATM when I create a new job, the list displays all people including those who already have a job. Can anyone assist with this please?? I have attached the file. Thanks. DWINDLING TEXT FIELD FOR FORUM.fmp12
  11. The problem I have is probably a very basic error. I can create the dropdown list in the portal OK, but when I add a second student and select a sport it created a duplicate of that sport in the sport table!! I have attached the file. Thanks for any advice. StudentSportForumQuestion.fmp12
  12. I have a STUDENTS (parent), and SPORTS (child) table. The relationship id STUDENTS_ID in the STUDENTS table, to STUDENTS_FK in the SPORTS table. I have a SPORTS portal in the STUDENTS table showing the sport name. Can I make the sport field in the portal a dropdown list to select various sporta for various students?? Thanks.
  13. I have a portal showing total sales in a summary field outside the portal. I have duplicated this portal and filtered it to show sales > $100. How can I show the total sales from the filtered portal in a field outside the portal please. Thanks for any assistance.
  14. Thank you. I will give that a go. 😀
  • Create New...

Important Information

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