Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About effectsguy

  • Rank
  1. Hello all, I'm trying to solve a problem, and need a bit of guidance in the easiest solution. I'm modifying an existing db to suit my needs. In one table I have a list of items sold. So there will be anywhere between 1-10+ items (records) per transaction. Each item ordered is a separate record. Each "sale" has its own invoice number. For example, for invoice 0001, there could be 10 records in the sales history. So there will be 10 records and the constant will be the customer number and the invoice. Then in the customer table, I would like to have a portal that lists just t
  2. Hi wondering if anyone has run into this issue. I have some log ins with mainly data entry permission. I do not want them to be able to modify the value list, only use them. But if the field set up is set to allow edit in the value list, the person can go in through there and change the value list. Do I need to turn off the edit function? I want people with full access to be able to edit the value list while in the drop down or pop up menu. Thanks for the input.
  3. Hi, here's my original post that I need help with. http://fmforums.com/forum/showtopic.php?tid/189729/post/265206/hl//fromsearch/1/ I'm doing this job for very little money and have hit a snag, so I'm not able to pay much. Please let me know if you're interested and about how much you would charge. I'm going to create a clean copy of the file later today for someone to see as an example and also work with. Thanks a lot!
  4. [color:blue]Hi Fenton, thanks for the help so far. My response and further info...
  5. [color:blue]I forgot to mention that it will be cleared out once the export is finished. Here's how it will be used: Table 1 holds all contacts Table 2 currently holds 2 portals as described above. Table 3 is the table that contains the "additional contacts" for manual entry. Table 4 is the final destination to receive the "checked" contacts from table 2 and all manual contacts entered into the other portal. The idea is you go to Table 2, it shows the full list of available contacts that are related (based on a city field in table 1). But not all of those people need to be
  6. Hi all, anyone have any thoughts on this? I have 2 related databases, related by city (in a contact list type layout) One db contains the contact info and the other is a form view of sorts, displaying all related contact info. Currently I set it up as a portal and it's working well. I also have a check box in each record and I'd like to tell it to export (or import to another database) only those that are checked. I can get it to export all records in the portal with no problem, but I'm not able to reduce the export set by omitting the checked boxes. So essentially I'm get
  7. Apparently the new 9 update has taken care of this issue along with updating your windows print drivers.
  8. Thanks... Sounds like I'm just going to have to make a windows only layout. Oh brother.
  9. Thanks for the help. I'm going to cheat it and make headers and just make a sub summary only that will show up. It would be nice to be able to have that feature though.
  10. Hi, wondering if anyone has come across this problem... I created some layouts on my mac, and to print, I scale it 80% and print. All done via button when I want to print) When I switch to my windows machine and try to print to the same printer, it won't reduce. If I force it to scale to 80%, it takes what would have been printed at 100% (cropped on right and bottom) and shrinks that whole section down to 80% of the paper. It's still missing that 20% of the image. Had it "redrawn" the 20%, it would print normal. Make sense? I've tried it one 2 different printers. It's Filema
  11. Hi, I've created a report that prints two columns with a sub-summary header at the top. It won't print that sub-summary elsewhere unless coincidentally, it's forced because of the change caused by the sort parameter. I'm trying to set up a contact list with the sub-summary sorting by state and printing that at the top of each page, both columns, regardless if it's come to a new state. I tried setting up a header row, which printed the info I need, but doesn't keep the state sub summary header correctly. Here are 2 pictures, currently just has the sub summary field only. Than
  12. Thanks, everyone. Genx, your solution worked. I was missing that "constant" that caused the extra level of filtering.
  13. I have a Key Contact Check Box. That triggers the look up. Which works great for the first record. But fails if the key contact is not the first record.
  14. Hello, thanks in advance for any help. I'm trying to get a field to look up information based on the relation. Ex: I have 2 databases, one person contact and one company contact. I need the company database to pull a person's name but only if it meets a requirement. There will be multiple persons that belong to a single company. But there will only be one Key Contact person. I'd like to tell the company database to pull from these related batch of records, but only display the key contact name in the field. I've got it set up as an If statement, but it only works for the first r
  • Create New...

Important Information

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