Identifying Business Purchases

[locator8]

Hi,

I have been constructing a database for my daughter which tracks orders to her suppliers. When she puts a personal order in, some products are for personal use and others are promotional. I want to identify these graphically when filling in the order. This would work similar to a radio button but without two buttons. That is she clicks on a button and the field changes from a green to a red graphic. I have three fields; one holds the graphics, one displays the graphics and one indicates the type of purchase numerically (1 or 0), all repeating fields. The order pages consist of fields with vertical repeating values so as an item is entered, the button is clicked to red if neccessary and the numerical field ID the item as a business purchase. I have been trying calculations along the lines of

Set Field ("BPField"-10, "GetRepetition(BP Graphics, 2)")

without success. I have also tried using a calculation field as the graphics display field but only successful for the first repetition.

I had a sample file that I found on these forums for fancy radio buttons and checkboxes using case but have since lost it.

As always, any help is appreciated.

Dibbs

[locator8]

Hi again,

I have solved this problem in the short term by creating 2 container fields to hold the graphics rather than one with repetitions.

Dibbs

[comment]

IIRC, there was a bug in earlier versions affecting the use of GetRepetition() in a repeating calculation field.

In any case, using repeating fields for order items is not a good thing - you should use related records instead.

[locator8]

How would related records make it better? Would you mind taking the time to expand on your comment?

Thanks

Dibbs

[comment]

With a separate record per item, you can group your items by product (or by any other attribute) and get some meaningful reports out of the data. There are other aspects as well, but IMHO this is the most important one.