newbie post: pop up list/relationship Q and auto entry Q...

[justakid]

Hey all,

I hope it's not frowned upon to ask for help having only registered...

But I have just been thrown in the deep end with filemaker and have been asked to do a couple of things that I have no idea how to do...

First thing I need to do includes the use of auto entry and drop down lists

That is...

I have set up a section which has 3 pop up lists.

Pop up 1 = project

Pop up 2 = category

pop up 3 = category # - IE entry is #1 2 etc in that category

What I am trying to achieve is to change pop 3 to a auto entry. I want the auto entry to increment by the value of 0001 each time a new label is created. The catch is that I want it to rely on what is select in POP UP 2.

EG:

Proj = 01 Category = 01 Category # (should) = 0001

Proj = 01 Category = 02 Category # (should) = 0001

Proj = 01 Category = 03 Category # (should) = 0001

Proj = 01 Category = 01 Category # (should) = 0002

Proj = 01 Category = 01 Category # (should) = 0003

Proj = 01 Category = 03 Category # (should) = 0002

Proj = 01 Category = 02 Category # (should) = 0002

So that iis how I want it to work, the only issue is I do not know how to (is it possible?) make it so the category # incrememnts automatically the way I want it to...

The other thing that I wanted to do was to relate two fields

EG:

I have two fields

"Category" which is reprensented by numbers

and

"Category name" which is a popup list represented by text.

What I want to do is have it so "Category" becomes an auto entry based on what is selected in "Category name".

EG Category name has several entries

Draft

Master

Screening

etc

When you select Draft I want "category" to automatically have 1 entered to it

When you select Draft I want "category" to automatically have 2 entered to it

When you select Draft I want "category" to automatically have 3 entered to it

And so on...

Hope I am not asking too much let me know what you guys thing.

Cheers,

Justin