Jump to content
  • 0

Cascading Text Field Pulls in Wrong Information


ChristianM
 Share

Question

Hi All,

I have a Submission DataPage with the following setup:

s_Stock = AutoComplete field that gets value from View A (view of Table A).
Multiple Cascading Text Fields that use the s_Stock field as the parent field to then pull cascading values from Table A.

The setup for the Cascading Text Fields:
Parent Field = s_Stock
Lookup Table = Table A
Filter cascade by = stock_number

The issue is that the Cascading Text Fields will sometimes pull in the wrong information. For example I have stock numbers 46207 and 46207C in my view.
Here are my values in Table A:

image.png.7e4cde282bcaf7f190ae63c80dd27fcb.png

 

When I type 46207C, the Make field pulls in the "brand" field from Table A which should be the "NORTH TRAIL" value. However, what actually populated is the "CHEROKEE" value (the value for Stock 46207).

image.png.7067f0091fdc88ad56e42f7546e5745a.png

It seems as though the filter aspect of the Cascading Text Field isn't taking into account the full value but instead the shorter value with same partial characters.  Any ideas?

Thanks!

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...