Alpha Software Mobile Development Tools:   Alpha Anywhere    |   Alpha TransForm subscribe to our YouTube Channel  Follow Us on LinkedIn  Follow Us on Twitter  Follow Us on Facebook



The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic

Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.

If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.

Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.

Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

one 2 one link to table with Jpeg Image Field

  • Filter
  • Time
  • Show
Clear All
new posts

  • one 2 one link to table with Jpeg Image Field

    Iím trying to use a memo field and a jpeg image field in a desktop database Iím creating.
    I want to have the memo field and image field in their own tables, with one to one links to the parent table.
    I have tested this in a three table test database. I can get the memo table and field to work fine, However, Iíve had no joy with the jpeg image field table. The field doesnít import the JPG and the link field doesnít get filled with the parent link.
    Iíve looked through the forum to see what I might be doing wrong and tried many ways to make this work. Iíve seen problems and recommendations to not use this field type, but didnít see anything about this field type not working. I have tried the ďimage file referenceĒ field type and it does work, but I would prefer to put the image in the database where it wonít get deleted or be moved. The database will only be about 100 records, so I donít think there will be a problem with size.
    I would appreciate any help finding out what Iím doing wrong.

    I'm going to try to include the test database I've been trying to get to work, along with a couple of the JPGs

    Iím on - Ver. 9 platinum edition build 2095 addins: build 3264

    Attached Files

  • #2
    Re: one 2 one link to table with Jpeg Image Field

    V9 Platinum same build.

    Please see attached, which may give you what you require.
    I have created a new Set with the Pic at the top.
    Changed the NameID to Numeric 4. This is beause it is better to use numerics if your application is going to be ported anywhere like an SQL environment. It is also more complex using Char as a linking filed.
    Two types of pic shown on the test form.
    1) where the pic is just a reference and
    2) where it is embedded.

    You need to click out of the box to display.

    Both have merit, although some people advocate having the reference as there is no need to hold the pic twice.
    If you have a formalised proto session at say every 5th year to keep access passes fresh, then if the same refernce is used, the pic should be current.
    Attached Files
    See our Hybrid Option here;

    There are 3 things you can do in any situation;
    Live with it, Change it or Walk away from it.


    • #3
      Re: one 2 one link to table with Jpeg Image Field

      Thank You for your speedy reply.
      Unfortunately Due to circumstances beyond my control, I will not be able to review the material for a few days.
      Please bear with me.
      Thanks again


      • #4
        Re: one 2 one link to table with Jpeg Image Field

        Appreciate your help and interest.
        Thanks for the examples of other methods. Iíd prefer not using the ďimage file referenceĒ field as it is to easy for clients to move and delete stuff. Also, embedded images make the database more portable.

        Having the Picture table (Jpeg image field) as a parent table causes other issues, as there is always a Name entry, but may not be a Picture for the record. I also donít want the client to change or enter the record id for the picture table, so it will have to be auto increment. I think if the picture id is auto increment Iíll end up with the same problem I have now.

        I really believe there is a BUG associated with the ďJpeg ImageĒ field type, being in a child table, in a ONE to ONE relationship, with the only other field being the link field. When this situation occurs, and a picture is imported, neither the link id from the parent record, nor the picture, end up in the record.

        Iím sending a zipped database, in the simplest form I can, to prove this and would appreciate it if you would take the time to enter two or three records consisting of a name and a picture.

        Then default browse the Picture table and verify that you too donít have any records, link ids, or pictures in that table.

        That would tell me itís Alpha and not me, or my PC, and then I will stop trying to make it work and find another way to accomplish what I want to do.

        Thanks a bunch
        Attached Files


        • #5
          Re: one 2 one link to table with Jpeg Image Field

          Vince, not sure if this helps or not, but I have added 4 pictures using the Auto Increment, and one No Pics - name only.

          Have a look at the [picture_01 set structure. Sets are created at runtime, so they can be any configuration you want them to be.
          The test form works with that set.

          I can confirm that if you put the picture table as a subbordinate in a set like you have been doing - it doesn't work.
          However, with a bit of tweaking it can be made to work.
          Attached Files
          See our Hybrid Option here;

          There are 3 things you can do in any situation;
          Live with it, Change it or Walk away from it.


          • #6
            Re: one 2 one link to table with Jpeg Image Field

            It seems that method gets the first record out of sync and you never have a name in the first record.
            I could use It myself but can’t give it to a client.

            If you take a fresh copy of the last database I sent you (make sure the tables have been cleared), go to the picture table and only change the field type of the picture field to any type in field (try memo, numeric, or character) and save it, the database will work the way it should.
            The jepg image field will also work if there is an entry field in the same table before the jpeg image field (what’s that about).
            I think the jpeg image field will work in a single field (plus link to parent and auto increment pictureID), one to many link, table.
            No consistency on how you use this field type.
            The use of a field shouldn’t be determined by the link type, that’s BS.

            I think it is a broken field type that has never worked, as it should, and probably still doesn’t work in V11.

            I’ve about given up on this one, it’s wasting too much of Your, and My, time.

            I just won’t provide a contact picture or will embed the picture in the parent table amongst all the other crap they want, ugly thought.
            Could also give them multiple pictures per contact, with a one to many link picture table.

            Thanks a bunch for all your help


            • #7
              Re: one 2 one link to table with Jpeg Image Field

              Yes you are correct Vince.
              Only thing I can suggest is that you create a separate table as you suggest.
              I'll give a bit more time after the celebration weekend here in the UK, as there really must be a way around this, however if you populate the Names table first, then adding a Picture can be done the way you want to.

              Edit. Had another fiddle.
              It's not possible to add a picture using the Set.
              If you look at the Alpha Sports example, Salespeople ID/Name and their photo are in one table.

              Is there a reason you cannot do the same?
              Last edited by Ted Giles; 06-03-2012, 07:00 AM.
              See our Hybrid Option here;

              There are 3 things you can do in any situation;
              Live with it, Change it or Walk away from it.


              • #8
                Re: one 2 one link to table with Jpeg Image Field


                That's an excellent work around.
                I always look to alpha sports for answers, but it didn't click this time.
                I'll use the Name and picture as a parent table, other crap in a profile table as one to one, Memo field table one to one, etc., etc..
                That should keep any one table from getting bloated, if the image file is kept small.
                Wouldn't have a solution without you.

                Thanks again for your help