I have a purchasing system which has a PO Number composed of the date, purchaser's initials, and if it is a second PO for the day it becomes 1, 2, 3, and so on.
So, for example if on 7/29/2004, Bob Thornton was going to make his second purchase order form of the day, his PO number would be...
I've got a database that displays 4 portal rows. However some records only need 2 rows, yet when we print there is a 3rd empty row displayed (the one where you'd put the next portal row in)
How do I make it so that this row doesn't show? Limiting it to displaying 2 rows is not an option since...
Ok, I have two databases, one for Sales Invoices and one for customers. Inside the Customer database, I have a portal that shows the invoices for the particular customer.
It was working fine when I specified the relationship for each record to correspond to Last Name. I realized this was an...
I have First Name and Last Name combined in a calculation in two files.
Can I use this calculation as my primary key in a relationship?
what is a way around this? I don't have any other possible primary keys
I've got a database with vital customer information for our company but the last person left without leaving the password to access certain layouts. is there any program that can crack the password for this? seems simple enough
I want to combine the fields First and Last name into one field called Full name. I tried using a calculation but the field stays empty for some reason
What am I doing wrong?
I have a DB with Invoices that contains a portal to a DB with Line Items.
For each part number, there are two fields specific to that part which I'd like to automatically fill in. I have a part number database which contains records for each part number and values for the 2 specific fields...
I have a database of customers, inside that database is a portal to a database of invoices.
I want to find out how many of a certain item number they have purcashed.
I tried using the exact function in a calculation field but it returns only a 0 or a 1. how else can I get it to count how...
http://www.myob.com/us/odbc/
I wish I could use this interface however we are running macs and it is not compatible. has anyone used this interface? how is it? does anyone have a replacement for such a tool?
obviously because there is no applescript in pc's.....my question is are there any replacements for applescript? it sucks that i have a gap left open in some of my major scripts, feel like im back to square 1 any help would be appreciated.
Thanks,
Matt
ok I have a database for invoicing, and the plan was to have a button with a script that copies and pastes the part number, searches for that, then copies and pastes the quantity of that part and pastes it in the inventory field. problem is how do i get filemaker to add these two numbers? also...
each packing slip is a record. I've created a portal which lists each item. I need to have an item number for each object. auto serial wont work cuz for each packing slip it needs to start at 1 any help is appreciated very much. thank you
So the need came up for me to be able to exclude certain records from a print. So I made a field with a radio button value 0 or 1 and made a script with a search right before printing to find those records whose value was 1 therefore the 0's do not get printed.
What I would like to do is...
I set a password with limited priviliges including no menu access. I also set filemaker to automatically try the limited password, so now it's impossible for me to enter the admin password to get back in. :( what do I do?
I have a field for price. I want the admin to be able to go in and edit its value but I do not want the production users who use the same database to be able to see this value when they use the database. I was thinking of using passwords but I'm not sure how exactly to do this. Any help is...
This is what I'm trying to accomplish:
I need to make a form for a clerk to enter orders into. Clients request one type of product to be delivered on several dates, each date has a quantity delivered.
I created repeating fields for this purpose and this works fine so far until I was recently...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.