I have a number field in the form and it has value 1 or 0. I have a lookup rule based on this and field in the database that is a bit field. The data is not coming back in lookup rule depending on the field value. Any help please?
Thanks
Priya
I have a number field in the form and it has value 1 or 0. I have a lookup rule based on this and field in the database that is a bit field. The data is not coming back in lookup rule depending on the field value. Any help please?
Thanks
Priya
Can you post a few screenshots of your fields and how the look up is set up?
Sure, please see attached. Thanks.
Priya
Have to tried showing the auto fill button and clicking it to see if the issue lies with the autofill not happening? Have you tried using True or False as the values in Forms to match the 1 or 0?
I have tried True or False and it is not working. Let me try auto fill. Thanks.
Priya
Hi Priya,
Looks as though you're hiding fields. Are you hiding them through field rules? If so, make sure that the data in the hidden field is saved:
Ok, thanks, will check.
Priya