Placing image on tablename_templateDVP

[ronwill]

Hi,

I have no problem inserting images on DV/DVP templates but would like a solution to following:

I have a customer input form where client uploads an image (which obviously can be displayed on both the respective DV & DVP templates), but can I 'get/call' this image and place it on a different_templateDV / DVP? (Sorry for 'get/call' usage, am not a programmer so don't know correct terms).

Purpose/Goal: Want a client (multiple) to upload their logo say just once onto their unique profile form that I can then have included on any invoice or any other form prepared by them by including their image onto the template forms. At present I have it set where they upload their logo image each time they prepare an invoice which is not practical, takes more time & I'll end up with more server storage being used for the same image being uploaded each time invoice created by users.

I'm sure it's possible, just can't see how at the moment so helpful solution appreciated...

Cheers, Ron

[grimblefritz]

Ron,

Create a "Client_Options" table, with one record per client.

Create a field for a logo, or photo, or tag line, or whatever else you need.

The client can upload the photo once, and then you can reference Client_Options->logo, which will contain the image file name.

[ronwill]

Excellent, thanks for that I'll give it a go

[ronwill]

I should have thought of using the 'look-up field' in AppGini axp file generator to Lookup an image (logo) file! (I'm a donut!)

As I already have a client profile table (limited to 1 record per client - something else I gained knowledge of from this forum) all I had to do was add a logo field on there & then select the field from my invoice table with auto-fill enabled and job done! Logo shows fine in table/detailed view & DVP Template file - just what I was after.

Thanks for responding & helping me sort this out.

Cheers, Ron

[grimblefritz]

You're welcome. Glad I could help.