Hello

I have to design a basic database to keep track of butcher shop transactions as a school assignment. I have 2 files linked by a relationship. One has all of the products and their pices in it and the other keeps track of all the transactions.

I use an id number to enter the products through a reapeating field which looks up the names and prices of that product. My question is how can i get it to display a picture of that item in another field when i enter that id number??

I will attatch a screenshot of it in its early stages which might help you understand better. Any help would be greatly appreciated.

Thanks in Advance

Toby :

Hi, tobsta.

Have you in products file container field with pictures?

Where you want see the picture of the product? In the line? So smal picture?

yeah i have a container field with the pictures in the products file and wanted it to display the picture next to the items, not in the lines but as a big picture that changes according to the porduct's id number.

I made it as a look up field but then it doesnt change when i enter the next item. Any ideas?

Hi, tobsta.

Before each portal row you can put Button "Picture" and have container field near portal. When you press button must work script which shows picture in this field.

If you want viewing picture when you are choosing id. You can instead choosing it from value list open new window of product list, where you can see id and picture, then choose id from this list and add his picture to your field near portal. Here you must have few scripts which does it. Sorry for my english.

thats ok , but im not really following. The criteria i have to follow uses repeating rows and not portals. I thought it would be simple. It seems simple but obviously not. If i could only get the look ups to update when i entered the new product it would work.

Hi, again tobsta.

I created example for you.

One Discomfort is that if you choose id you must press view button for picture viwing.

Pic.zip

ok, thanks but your scrip writing looks to complicated for me and i think it would just be annoying having to click a button. I think i will scrap the idea if i cant get it display automatically

is there any funcion that automatically updates look-ups when you re-enter data? So the image field, i guess in a way becomes dynamic instead of staying static onces its been looked up?

Edited July 5, 200619 yr by Guest

... Um, why not just make it an unstored calc field that pulls over a relationship between your parent tables id field and your child photo table's foreign id?

Hi Toby

this is a modified version of your file.

Take a look...

TransactionRev1.zip

Bravo, Raybaudi!

Until now i thought that calculation

GetRepetition ( product_id ; Get ( ActiveRepetitionNumber ) )

is unstored calculation and cannot be index.

And one question over. Can we do it in case if it is portal?