UFOGoldorak

Awesome, thanks!

Any way to get Filemaker to tell me the size of an imported image? As in KB or MB? On a separate note, when images are imported into filemaker, where do they live? Thanks, Paul

Pure genius.. Much appreciated!

Hello — I have 2 tables. On the main I have a portal for items (description, qty, price etc..) Some of these items will be marked with a checkbox to say that this item is a stock (ie paper, boxes, shrink wrap etc..) and not actual product. Items table and main table are related through a Jobnumber.. Right now on the items table I have a sum field for a total. This gets me a total for all the items in that job. I need to be able to get a total of my products and a separate total for my stock. Is that possible in one table? Thanks, Paul

Thank you, that was good reading material but I am still not sure how to accomplish what I need done. Here is a simple test file of what I am trying to do. Everything I have tried either gets me the same "Name" for both shipping and billing or nothing at all. I just can't figure out how to make it display 2 different records or 2 same records from the contacts table at the same time in 2 different places on one main layout. Thanks.

Would it be too much for me to ask what a foreign key is? Or would you mind pointing me in the right direction with a link to read? Thank you for your time.

1 record per address on the contacts table. The 2 addresses don't always match to be on the same record. Sometimes they will be the same, other times the addresses will be different. In other words some times i will ship and bill "John" and other times I will ship to "John" and bill to "joe". Here's a couple of screen shots..

The viewer table and layout just combine all my info from other tables be it portals or calculations into a front end to my database. It for example has a job number field that relates to an items portal from another table that lists everything that need to be done with that job. I would like to add a "ship to address" and a "bill to addres" sections to that layout. It's no problem if I only needed one or the other then I could just add a portal. Now since the bill to address and ship to address don't always match, how can I make it where it accesses two different records from the "Contacts" table? Hope that makes sense. Thanks.

I've got a contacts table and a viewer table. How can I display 2 different records from the contacts table onto the viewer. ie one address for billing and another address for shipping? I've searched and apparently nesting portals won't work. Aside from having exact duplicate contacts tables or copying the field info back and forth what are my options? Thanks.