Problem with Hash Cookie from Lookup is not recognised.

[steven]

Hi All.

I have a quote form that calculates stuff based on the company being quoted.

But the After Browse won't recognise the company_id ...



1. When using autocomplete before opening the Browse Form the company_id (sal_company_id)
2. Can't be used when caluculation a product's cost.
3. It looks for the company_id with a Hash Cookie.
4. But it leaves it blank.

It only happens when typing something into the code field and then using then opening the lookup's Browe Form.

autocomplete_problem.png

I have attached the problem db.


I appreciate any help.


Steven

[kev1n]

Hi Steven,

When opening the form MMAD, I’m getting SQL errors because the table #1146 – Table 'ship_status' doesn’t exist.

And could you let me know which form / form code is actually causing the error you mentioned above?

Kev

[steven]

Thanks Kev,

maybe its missing this...

Code: Select all

DROP TABLE IF EXISTS `ship_status`;

CREATE VIEW `ship_status`  AS SELECT `ship`.`ship_id` AS `ship_status_id`, if(`ship`.`shp_printed` is null,'not_printed' collate utf8mb4_unicode_ci,'' collate utf8mb4_unicode_ci) AS `sta_printed`, if(`ship`.`shp_invoiced` is null,'not_invoiced' collate utf8mb4_unicode_ci,'' collate utf8mb4_unicode_ci) AS `sta_invoiced`, if(`ship`.`shp_delivered` is null,'not_delivered' collate utf8mb4_unicode_ci,'' collate utf8mb4_unicode_ci) AS `sta_delivered`, if(`ship`.`shp_shipped` is null,'not_shipped' collate utf8mb4_unicode_ci,'' collate utf8mb4_unicode_ci) AS `sta_shipped` FROM `ship` ;

But I've added the db again.





The problem is with the Q - Quote Form and QSF - the subform Lookup Object.

Hopefully this makes sense.


Steven

[kev1n]

I wasn’t able to reproduce the behavior you described.
To illustrate, I’ve attached a short video showing the steps I took.

However, I did notice that the database version is from 2024.
It’s therefore quite possible that the issue only occurs with older versions (I have used the most recent one to test it)

[steven]

Thanks, I should have made a video to explain it better.

Rather than using the magnifying glass, try

1. typing COP in the code field.
2. tabbing out of the field (this will open up a lookup, filtered with items that match COP).
3. Select COPLEY CO. from this lookup.

Now the Subform's Lookup can't use #sal_company_id#.


(Its weird)

Steven

[kev1n]

That's exactly what I did in the 3rd row. I didn't click on the magnifying glass but used the tab.

[steven]

Kev,

I found it only happens when creating a new Quote.

If you reload a quote the sal_company_id is in the Hash Cookies, but it doesn't go in the Hash Cookies, if you are creating a quote for the first time.


Steven

[kev1n]

In my video, I also created a new record. But the hash cookie was still resolved.