Jump to content

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


justakid
 Share

This topic is 5654 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

This topic is 5654 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.