Form & Field Help Please..newbie

[MyTonkaToys]

Relative newbie needs help. I have attached a jpg of a FM form I designed and am using to display product "specials". Each box on the form represents part number(s) that I sell. Currently I am manually entering the price into the jpg when I create it..so it's actually part of the jpg. What I would like to do is to use the related database that contains the p/n and pricing data to display the part pricing for each of the p/n's displayed in the jpg's. Is that possible? ..or am I just brain dead over here?

[Raybaudi]

Hi

why haven't you stored those "HP fuser" images into a container field of the related DB ?

[MyTonkaToys]

I have..but the artwork for the "specials" is created outside of FM. I cut and pasted them as jpg's into the FM form. Now I just want to display the price from the related pricing DB for each specific part number. Do you think that is possible?

Thx, Mike

[Raybaudi]

Mike,

this is a normal job for FileMaker...

So you have a container field , a price field, a part number field etc in the related DB.

You can put all those field into a portal with some large rows, each containing the container field and the price field; the last one may be over the container.

BTW: send us your file and some pictures...

[MyTonkaToys]

I think I understand what you're telling me. I have 200K+ part numbers I am dealing with and only a small subset are the "specials" that contain jpg images. Are you suggesting I create another data element in my parts db to indicate it is a "special" part and then change my "special" to not have it with the jpg's like I do now..but instead have a Portal?

The picture I have attached is the opening screen where the "specials" are listed. Each "special" is a button with a script to jump to the "specials"

Thanks so much for your advice.

Mike

[Raybaudi]

Yes.

Portals can be filtered and, I think, you just had do it.

What kind of record I'll see if I push the "HP" button ? And in wich layout ?

That layout can be modified to show a portal with a vertical scrool bar that contains the container and the price field.

Remember that you can make a self-join relationship, so that you can view all the records into a portal.

[MyTonkaToys]

What I was trying to accomplish was to have something that you can not just view...but also to be able to fit on a page to print out should the user want a hardcopy. I was really hoping that FM would allow me to place a value for a specific p/n anywhere I wanted to on the page. Sounds like I have to do the container & portal...oh well. You asked about the buttons..This program provides bill-of-materials for service parts for HP, Lexmar, Xerox, Canon..etc. It's searchable by p/n or model number. Everything works fine except for the problem i'm having displaying individual p/n pricing.

Thanks for you help...Mike

[MyTonkaToys]

I've attached the relationships of my application. What I'm trying to do is to create a form to display "special pricing" for select items (p/n's) in the DB FMParts. I have a container in FMParts that has the image. When I created the new Form I inserted a 4 line Portal to display the image, p/n, pricing etc. However, when I am in that new "specials" Form and do a search on the p/n it displays the wrong p/n. i.e. if I searched in the p/n field of the portal for "ABC" it allows the search but it displays "123". I will attach a jpg of the portal form in the next reply.

[MyTonkaToys]

here's the Form with the Portal. This is the one that displays the wrong p/n

[bruceR]

Your relationship graph indicates you have different tables for different manufacturer's parts. This doesn't seem right. The manufacturerID should just be another field in the table. So you would get rid of Lexmark Models/Lexmark parts for instance.