effectsguy

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 the total per invoice so I can see their past order history. No need to list every single item ever ordered, just a summary for each order. My order page is sorted by invoice number with a subsummary after each invoice. That's the information I'd like to have shown. Thanks very much!

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.

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!

[color:blue]Hi Fenton, thanks for the help so far. My response and further info...

[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 imported into table 4. You check the ones you want and only the checked contacts get imported into table 4. I'm not as advanced as most of you, so I'm trying to figure it out best I can. I'm completely open to the proper structure if mine isn't the best way. Thanks again.

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 getting too much info. One current way I can think of is by doing the import and then immediately having it do a find for the check boxes and delete those out. Seems like the long way about it though. Thanks for any help!

Apparently the new 9 update has taken care of this issue along with updating your windows print drivers.

Thanks... Sounds like I'm just going to have to make a windows only layout. Oh brother.

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.

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 Filemaker specific in Windows. I'm using 8.5.2 on Windows and 8.5.1 on Mac. Thanks for the help!

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. Thanks again.

Thanks, everyone. Genx, your solution worked. I was missing that "constant" that caused the extra level of filtering.

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.

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 record. If any record after that is the key contact, it doesn't work. Any thoughts? I just can't get it. Thanks.

Hello, can someone help? This is driving me crazy! I have a multi file database that has some relations. One file is a "contact" file with all the people, addresses, etc that has around 100 records. The other file, "Groups" needs to show 2 of the contacts in one record but each in a different tab. Example: Group 1 has moderators x & y, Group 2 could be moderators a & b, etc. If you click on Moderator 1's tab inside the group layout, it pulls up their contact info (looked up from contacts database) It works okay for one name, but the problem is that when I go to put in the other persons name, it only shows the looked up data from the first person's contact. I've tried portals, multiple file references, ect, with the same result. Any suggestions?? Thanks all, great forum. Sorry if this has been posted before, there's a ton here.