Custom Script help.. IF? Validation?

[pryjda]

Could someone please help me? I am having trouble with writing a script and i'm at a loss to get started.

What i would like to do is create a script that will do one of two things.

First i have 3 fields ITEM, TRIGER and MASTER.

ITEM is required, always.

TRIGER needs to be Boolean

MASTER is required ONLY is TRIGER is true.

if TRIGER is false, copy the contents of ITEM into the MASTER field.

Either way MASTER needs to be populated with something before the record is finalized.

I would appreciate help with this.

Thank you so much, this is a little too advanced for me.

pryjda

[aldipalo]

I think we need a little more info before we can give you advice.

How many tables?

What are you looking to accomplish?

What is the purpose of your application?

[pryjda]

I apologize for being too brief.

Thank you for your interest in my post.

All if my fields are in the same table.

This is a very simple application used to help organize picture for a web site.

I a nut shell, every ITEM needs a MASTER to tell the system which picture to copy.

If no copy is necessary, the item is then considered its own MASTER

A user sets a number ( ITEM ) really its a part number for example 2300 a T-shirt, Red, Small

This item is a “master number” because there is several more T-shirts, Red…. M, L, XL, XXL each with its own part number.

M = ITEM 2301

L = ITEM 2302

XL = ITEM 2303

XXL = ITEM 2304

On the back end ITEM 2300 has an image named “2300.jpg”. Then though a simple VB script, this image is duplicated then named 2301,jpg, 2302.jpg etc.

Resulting in 5 images all essentially the same picture each with its own part number / image name.

I have already created my VB program and it works beautifully. But so far I am only able to process my images based on a manually entered Excel spread sheet. What a pain. This application is used to process thousands of images every month.

Again, thank you for your interest in my dilemma.

If you feel as though I have not explained my program properly please let me know. I would be happy to discuss this further.

pryjda