Lookup value incorrect when using View

Yeah I notice that the duplicate record cause lookup to mess up.
I try creating new view that only connect wpch_users and customer table, It looks ok now.

Ok, I’ll try again. I think as long as the view doesn’t have multiple value for one primary key it’s ok for entry lookup.

I have more question, a bit unrelated.
1. Is it possible in parent/child type to disable edit mode, but in the child I enable the edit mode

Table 1 – Type: parent/child, Mode: View, Allow Insert : No, Allow Delete : No
Table 2 – Type: table, Mode: Edit, Allow Insert : Yes, Allow Delete Yes

I want to edit only table2 that has relation to table1, but disable editing mode for table 1 ( prevent unnecessary editing )

2. What is “Less ?” means in “Manage columns for data entry” option in “Manage Table Options” Tab ?

3. Got a ERROR: Wrong arguments [missing primary key value] when adding new entry

I read on one of the article in the support that I need to update from bitbucket repo, Is this true ?

4. Cannot remove pages from projects
I cannot remove page from project even If it doesn’t have any relationship (static )
Have to remove it from database manually, any effect by doing this ?

• This reply was modified 6 years, 9 months ago by wpsd2006.

Hi thank you for the reply

>>> I think as long as the view doesn’t have multiple value for one primary key it’s ok for entry lookup.
You can add a lookup for a table or view with multiple column keys as well. Directly behind field “Source column name” there is a plus icon. If you click on that icon you can add a relationship with multiple columns.

Still confuse with the logic behind n:m, I’ll further test it.

Q1) This is not possible at this time. But I added it to my to do list! 🙂 Great idea!

Great, thanks. It’s ok If I the only one use it, but if other people I have to give a little bit of restriction 😀

Q2) If you have a parent with a lot of columns you can uncheck the less option for parent columns you don’t want to be shown by default. If at least one column is unchecked a button is generated for the parent that allows you to switch between less and more mode. Please check out the video in the online help on this topic: Data Projects – Video Tutorials > (4) Data Projects add a less/more button to your parent-child forms.

Lol – sorry for the stupid question, I just notice it.

Q3) You can download from Bitbucket for your own development but please don’t use a Bitbucket version in production. Bitbucket is work in progress and you might run into other (bigger) problems. You can download a pre-release from the current development that should be stable and solves this issue from here:
https://drive.google.com/file/d/177IVh4U8zlbcdWFPR-oUaU-gfO5XYCs0/view?usp=sharing

There is a problem I face now, I need to fill the whole column even if it is allow to be null in the table when adding entry. After successfully adding it then it cannot be remove.

I think this was ask by other ticket, maybe add a “debug mode” so when there is an error you print the sql query that cause the error. I know we can check from sql log, but it is a bit difficult to see that in share hosting.

This way we can track better what we do wrong in the settings.

Q4) You can safely delete a project page from the Data Explorer. I was able to reproduce this error on my computer, so I added this issue to my to do list and will fix it in the next release. Thanks for bringing this issue up! 😉

Awaiting for next release

• This reply was modified 6 years, 9 months ago by wpsd2006.

One more feature need to allow negative sign on numeric entry