Search results for query: *

Hi, helpful folks, I'm having a heck of a time with the "Current Date" concept. It seems like a simple enough thing to do, but I just can't get it to work. I have customers with subscriptions, each with an expiry date. I have a field that indicates whether that customer is "active" or...

False alarm. I deleted the portal and created it again and it's no longer happening. Whew!

My basic business model ended up having the customer info and the billing info in the same table (I tried to separate the two, but my inadequate expertise just couldn't make them work together). . A related table has payment information. On the main layout, I have a thing with four tabs. One...

Beautiful. Tks.

Read everything I could about the current date and how dates work, and not sure if I can do this. Each order is delivered monthly. The order is for a specified time period, usually one year. I want to designate the records as "active" or "inactive". To do that, I need to compare the expiry...

Here's what I've done (making sure records are committed along the way). The "customer info" record is a "new record" add. I fill in all of that info. Then, I scripted the button to -move to the "order form record" (which is based on a related table) -create a new record. -save the customer...

Basic business database model with three tables: -customer info/table -order/invoicing layout (and table) -payments layout/table I've got the relationships between then (simple, linked by customer ID) and everything seems to work, except one bug I can't seem to figure out. The string of...

Beautiful. It's working like a charm so far. You're the best.

OK, that makes sense. And it's quite simple. My issue is in the technical details of how to actually go about it. To create those relationships, do I have to create a "customer ID" files in each of the three tables, then relate them? Or do I create it in only one place (the customer info...

Filemaker newbie here. I've got the basics down, but here's what I need to do, and I'm afraid I just don't quite grab the hang of the relationships issue (which is clearly key). Any conceptual help will be appreciated. The business has a list of customers. The customers made orders (for which...