Portals & Pop up lists

[Rochelle_505]

Hello all,

I have two fields in a portal (month & year)that are defined as a pop up list. The pop up list is defined with value lists, month(jan,feb,march,etc)and year (2005,2006,2007 etc). During data entry when you select the year filemaker puts this year in all of the portal rows below, but when you select the month from the list it only adds the value to that field. I need the month to do the same thing, but I can't figure out how the year is able to do this when both fields are configured exactly the same. If I can get the Month field to do the same thing I can save so much time and clicking during data entry. Any ideas??? Thanks!

Example:

Month Year

September 2005 What fm is doing now.

(empty) 2005

(empty) 2005

(empty) 2005

September 2005 What I need fm to do.

September 2005

September 2005

[-Queue-]

Is the year field possibly a global? If not, can you attach a zipped sample of your file and tell us where the problem presents itself?

[Rochelle_505]

Hey Queue,

Nope no global or lookup fields. The only formatting they have is that they are pop up lists, and one is numeric and one is text. I even tried changing the month names to numeric such as 01,02,03 and still did not get the same effect as the year field. I have tried to attach my DB as a clone, but it is still too big to attach to my post.

[-Queue-]

Can you create a clone, delete all irrelevant tables, and then zip and attach the file?

[Rochelle_505]

Okay I uploaded my db, the name of the layout is Invoice data entry. Let me know if I am missing something. THANK YOU THANK YOU!!

Clone1.zip

[-Queue-]

I'm trying to guess the username and password, but it's not working. :wink2:

[Rochelle_505]

Sorry about that, please try:

username: admin

password: hypnotic

[-Queue-]

The Year field is from the current "Invoice Table" and not the related Line Item Table, on which the portal is based. So the value will be constant for all records in the portal.

[Rochelle_505]

:thankyou:

I did not realize I had two month fields defined, one in line item and one in invoice table. Which one should I delete? I am thinking the invoice table one and stick with only line item fields for the portal??Right? thanks so much for your help, fresh eyes are great when you've been looking at something toooo long! Thanks again!

[-Queue-]

If you want the date to be particular for each line item, then keep the one in the line item table. If you want it to be constant for all related records, keep the one in invoices, in which case there would be no reason to put it in the portal, unless you want to see the same value for it in all portal rows.