lrydant

When I tried using a another field for the lookup field and saved, the lookup field displayed correctly. Corrected to the recipename field, the correct field displayed. I did try this before but seems fine now. Thank you.

I think I solved my problem. I redesigned table so using as parent. Works good.

So when I set the Project Form mode set to edit and allow insert/allow delete/allow import set to no that is only for the parent table. However, I do not want to allow add or delete for the child table – only edit and edit inline fields which works great. Is this possible? Thank you.

Checked hosting services and A2 Hosting permits triggers.

After searches and inquiries, probably easier to ask. Any suggestions for hosting providers that permits the user to work with table triggers?

Thank you.

I tried executing. Get error WordPress database error: You do not have SUPER privilege and binary logging is enabled. Web hosting support said they support triggers but I have all the privileges they grant and can’t do anything else. Support suggested that maybe SSL certificate (haven’t done yet) would solve issue but doubtful.

So maybe I have to find new hosting service?

Thank you.

Disregard this issue. I’ve done better job of creating templates and the menu looks better. Thank you.

I’ve shared images.

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

Thank you.

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.

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

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.

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).

Took me awhile to understand that the order of the lookup field are key. Came out good!

This worked for the default where. Thank you!

(((group.groupid) In (SELECT groupid FROM member WHERE member_username =$$USER$$)))

I can not get this to work. I tried on the SAS demo and also on my tables which little simpler. I have group and member tables – each member belongs to only 1 group. I did as you suggested – created project page based on group with default where member_username = $$USER$$ and template with relationship of 1:n group and member with default where member_username != $$USER$$. Got no data with the default where in the project and the default where in the template didn’t seem to any effect on the data.

Only solution I can think of is to store member GroupID in the wp_users table but I guess that is a no-no.

Appreciate your thoughts. Thank you.