Jump to content

123

Members
  • Content count

    12
  • Joined

  • Last visited

  • Days Won

    1

123 last won the day on April 25

123 had the most liked content!

Community Reputation

1 Neutral

About 123

  • Rank
    member

Profile Information

  • Gender
  1. Thanks for the reply, there is a starter solution called "Meetings", however it doesn't solve my problem. There aren't any attendees involved, it's only about meetings and topics.
  2. Hey, I have the following problem. I'm working on a solution for the owner of several restaurants. Each restaurant has meetings once or twice a month. How would I structure the tables so that I could have a layout on which I select a restaurant and then inside a portal I get a list of all employees. On the portal for each row I want to have a button or checkbox to mark if an employee is present or not. I already have the following tables: Restaurants, Employees and Meetings So far I have a relationship between the Restaurants and Employees table which I use to assign employees to a restaurant, and a relationship between the Meeting and Restaurant table, which allows me to show all employees that work at a selected restaurant using a portal on the meetings layout. How do I proceed to solve my problem? Do I create another table MeetingAttendees or something similar that I use to keep track of people attending a meeting? How would I create a relationship then to allow me to mark certain employees as present and absent? Thanks in advance, Mike
  3. Hey, I started working with FileMaker a while ago and so far it's been pretty fun and fairly easy to learn because I worked with MySQL in the past. However, there are still a few questions I have. I'm used to having complete freedom when it comes to databases, because in Python or C++ for instance I would simply write my own queries and get whatever data I need, no matter if a database is related to another or not. Anyway, the flexibility is still what causes me some problems. I have the following problem. I'm working on an ERP (Enterprise Resource Planning) software for the owner of several restaurants. I need to have the following tables to start with: Restaurants Employees Jobs Visa Health Insurances Meetings Now, the person using the solution needs to be able to create as many restaurants, employees, jobs and meetings as they want and assign them to each other. For instance, Restaurant A is going to have 5 employees, Employee A, B, C, D, E and so on, and all these employees will have one or multiple (this is really important) jobs assigned to them. This process has to be flexible, so I can assign an employee to whichever restaurant and job I choose. You also need to be able to assign one or more visa to a job (and the assigned employee), the same goes for one or more health insurances. The next problem is about meetings. Each restaurant needs to be able to have meetings every once in while, which need the ability to keep track of employees that attend the meeting. So you should be able to select employees form a portal or card window (in FM16 for instance) and they will be added to another table MeetingAttendees or something similar. Again, this needs to be flexible so every restaurant can create meetings and check which employee is present. (I need to be able to create a layout to display the meetings and who has been present, if possible also to see who wasn't). Normally I would simply take the IDs and create tables that join these iDs together, however I'm not able to recreate this in FileMaker, if one relationship works, the other breaks for some reason. If anyone could give me a simple layout of what my database needs to look like, or if possible and not too much to ask an example in FileMaker. Your help is much appreciated. Thanks in advance, Mike
  4. FM16 Card Window in FM15

    Thanks a lot for the quick reply! Best regards, Mike
  5. Hey, what happens if I create a solution in FM16 and use the "Card Window" feature and someone else who still has FM15 wants to work with my solution? Will this work or is it not even possible to run the FM16 solution? Thanks in advance, Mike
  6. Hey, I don't know if people here are still looking for an easy way but I simply ended up putting "Top Navigation" parts on all my layouts (Layouts -> Part Setup). Every "Top Navigation" part has the same buttons on it on all my layouts and by clicking them you can navigate to all the other layouts. This simulates a static navigation bar that always stays in place, even if you scroll. I don't know if that's the way you are supposed to use it but it's really easy and works perfectly, Best regards, Mike
  7. Hey, yeah I don't want the default FileMaker menu (that you use to create new records etc) to show up in the final product. I made a navigation bar or menu that lets you create new records, perform finds, switch layouts and so on. I guess I will have to duplicate the layout I have right now and then edit it for all my other layouts. Thanks for the quick response, Mike
  8. Hey, I want to use the same header on all my layouts in FileMaker Pro 15 Advanced but I can't seem to find a way to accomplish it. I read on Google and other forums that there is no way to do it, however the posts I found are all at least a year or two old. Did they add a way to do it in FileMaker 15 or do I still need to duplicate a layout to get the same header on a different one? Thanks in advance, Mike
  9. Hey, thanks for the quick response. The first way you described sounds like a good solution, I will give it a try tomorrow, thank you so much.
  10. Hey, each line has a certain keyword. For example Payment or Order. Those keywords are in the same position in every line. Thanks for your response, Mike
  11. Hey, I have a Tab-Separated Text File which I want to import to a database that I just created in FileMaker Pro 15. The text file essentially is a log of events, for instance, one line describes an order, another line describes a payment that has been made. The problem is that I somehow need to import all these lines into different tables. I want all lines in the log file that describe a payment in a table called Payments, and all lines that describe an order in a table called Orders for example. I'm just starting out with FileMaker so forgive me if there is an obvious solution that I'm not aware of. I have a background in software development, so the only solution that I can think of is writing a small program myself that does all the parsing for me and creates separate text files that contain all the orders and payments and other events that have been logged in the file. Then I could simply import each file into the table I need all the data in. So to sum everything up, my main question is if there is a way to somehow parse the text file before importing it. I know that you can create custom scripts in FileMaker but I'm not sure if what I need to do can be done just with that. Thanks in advance, Mike
×

Important Information

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