Lookup field displaying on data entry but not list table

  • Resolved lrydant

    (@lrydant)


    2 years, 11 months ago

    I have 2 ‘identical’ view tables – second table deletes records from the first. If I use the 1st table, the lookup field displays correctly on both the List Table and Data Table. When I use the 2nd table, the List Table displays the ID but the Data Table correctly displays the Lookup field. Thank you!

    CREATE VIEW memberEvents_lookup AS SELECT event.eventid, member.id, event.groupid, event.datedistributed, event.datelocked
    FROM member INNER JOIN event ON member.groupid = event.groupid;

    CREATE VIEW memberEvents_lookup2 AS SELECT memberEvents_lookup.eventid, memberEvents_lookup.id, memberEvents_lookup.groupid, memberEvents_lookup.datedistributed,
    memberEvents_lookup.datelocked
    FROM memberEvents_lookup LEFT JOIN eventmember ON (memberEvents_lookup.eventid = eventmember.eventid) AND (memberEvents_lookup.id = eventmember.memberid)
    WHERE (((eventmember.memberid) Is Null) AND ((eventmember.eventid) Is Null));

Viewing 12 replies - 1 through 12 (of 12 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi @lrydant,

    Did you create a template for the second table? If so, you need to select the column to be displayed after creating the lookup. Can you check please?

    Thanks,
    Peter

    Thread Starter lrydant

    (@lrydant)

    I have one template. When I used table one, the date field displays correctly. However, when I swap table two for table one in the template, the ID not the date displays on the List Table (date displays correctly on the Data Entry, however).

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi @lrydant,

    My apologies for my extremely late reply! During my stay in Aruba I was not able to recharge my laptop battery which was limiting my internet access. I’ll try to pick up open issues asap now.

    If you open the Columns tab in the Data Explorer for both views, are the data types correct? Canyou check please?

    Thanks,
    Peter

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi @pixw,

    It this issue still open or can I close it?

    Thanks,
    Peter

    Thread Starter lrydant

    (@lrydant)

    I apologize – thought I replied.

    The data types are identical. I’ve checked and rechecked but when I select the first table in the lookup, the lookup field displays correctly on both the List Table and Data Table. When I use the 2nd table, the List Table displays the ID (not the Lookup field) but the Data Table correctly displays the Lookup field.

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi @lrydant,

    >>> I apologize – thought I replied.

    No problem!

    Can you please open the template, tab “Data Entry” and just save? This sometimes helps to (re)set field settings.

    Thanks,
    Peter

    Thread Starter lrydant

    (@lrydant)

    I’ve saved the Data Entry tab and not correct the issue.

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    What if you select another column to be shown in your lookup? Can you share your lookup definition?

    Thanks,
    Peter

    Thread Starter lrydant

    (@lrydant)

    I tried other columns and still the eventID displays.

    I would be glad to share my lookup definition. I’ve taken screen shots but not sure how to send to you or I can give you my login information.

    Thank you.

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi @lrydant,

    You can use this website to share images:
    https://imgbb.com/

    Thanks,
    Peter

    Thread Starter lrydant

    (@lrydant)

    I’ve shared images.

    Would perhaps issue be that the table view I’m using is based on another table view?

    Thank you.

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi @lrydant,

    >>> I’ve shared images.

    Can you please share the link here? Or use the contactform on the plugin website if you prefer to share your information in private: https://wpdataaccess.com/contactform/

    Thanks,
    Peter

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘Lookup field displaying on data entry but not list table’ is closed to new replies.