Jump to content

Jesse Stolow

Members
  • Content Count

    10
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Jesse Stolow

  • Rank
    novice
  • Birthday 03/15/1983
  1. Here is a copy of the file with some data entered into it. You can see that if you create a third record in the Main layout and pull down a client from the list, you will be unable to generate a printable Memo since we have already used that client before. Additionally, while I followed Bruce's instructions, the Script for this printable Order Form still does not show the correct record, or does it even show the manufacturer's info on the layout anymore. Total_Window_with_data.fp7.zip
  2. I wasn't able to figure out how to get bruce's directions to work. How do you set up a replace operation? I am sorry I am so slow with this. I was able to follow LaRetta, and now if I manually go to the Memo layout, everything shows up as it should--keep in mind I still have the relationship based on the names only. But when I run the new script, it still shows up all my records from Main. I just don't know how to set up the relationship using IDs and how to get things to replace numbers with other numbers in other tables. I guess it is hard for me to wrap my head around.
  3. This file will enable my company to write, print and keep record of quotes, contracts, and orders all on the computer (we are currently using the typewriter). I work for a company called Total Window that makes 100% fully custom window treatments (totalwindow.com). No two orders are alike. My problem is that the way I created the relationships and the Main table, when I select a Client from the drop down list for a new record that has a previous history of doing business with us I can't get my Script button marked Print Memo to print that specific order. Instead, it prints the first or
  4. There is no pasword. This file has no records in it for ease of use. However I have another identical file with a few records in it that I was using to test. Total_Window.fp7.zip
  5. this forum will not allow me to attach copy of the fmp file.
  6. I must be doing something wrong here because I tried what you said and it is still not working properly at all.
  7. Hey everyone, Sorry this is so long. I am a newbie and don't know how to explain it any better. Essentially, the main table I created is used to create and print quotes for a potential client (before they become a real client and get assigned a Purchase Order number). When I create a new record in the Main layout for a quote, I am able to select a client from a drop down menu that is tied to the Client table (which holds all client info). The two tables are linked by the clients name. I have also set up a third layout entitled Memo that is the printable layout for the quote. I
  8. Hey everyone, Sorry this is so long. I am a newbie and don't know how to explain it any better. Essentially, the main table I created is used to create and print quotes for a potential client (before they become a real client and get assigned a Purchase Order number). When I create a new record in the Main layout for a quote, I am able to select a client from a drop down menu that is tied to the Client table (which holds all client info). The two tables are linked by the clients name. I have also set up a third layout entitled Memo that is the printable layout for the quote. I
  9. Hey everyone, Over the past few months I have taught myself FMP from scratch in order to create a database entry system for the new company I am working for. We sell custom window treatments and are looking for a way to migrate from our antiquated paper based system into the more efficient world of the computer. Here is my problem (and I have attached the graph to make it easier to follow) Each individual order that gets processed may have more than one supplier providing the materials for the job. To track this possibility I set up the Manufacturer Orders table to be linked to
  10. Hey everyone, Over the past few months I have taught myself FMP from scratch in order to create a database entry system for the new company I am working for. We sell custom window treatments and are looking for a way to migrate from our antiquated paper based system into the more efficient world of the computer. Here is my problem (and I have attached the graph to make it easier to follow) Each individual order that gets processed may have more than one supplier providing the materials for the job. To track this possibility I set up the Manufacturer Orders table to be linked to
×
×
  • Create New...

Important Information

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