Return Based On Date Calculation

[jaygamel]

On the enclosed table of newspaper issues (twice a month, 22 times a year), I need to pick out the next issue number based on today's date. I can get the date to return, but I can't figure out how to get the issue number of that particular date into other calculations throughout the db (invoices, running ads again, etc.) I think I am missing a relationship configuration, but it continues to elude me. Any help will be appreciated.

The relevant file is Issues, but you can see how I'm trying to use it in the Classified section where I want to include an ad in the next issue via button/script.

I'm using FMP 6 on an intel mac with snow leopard. -- and yes, it gets slow.

Any help vastly appreciated.

jay Gamel

Archive.zip

[comment]

Try defining a relationship matching on date, and use a lookup to copy next higher value if no exact match.

[jaygamel]

It never fails: 30 seconds after I posted this question, I figured out the answer. I had the relationship structured wrong. Two clicks and everything's working fine. f

Thanks for your swift reply. I'll have more questions later, no doubt.

Jay

[comment]

Good. BTW, this could also be calculated - once you know the date of the first issue.

Similarly, in your Issues file, you can auto-enter the issue number as a serial number and calculate the date, volume, etc. from there.