Lookup field not populating database if hidden
Posted: 2022-03-16 06:19
I think I've found a bug in version 22.11 and 22.12. It's probably me but I need better minds to check it out.
I have an app for writing Job Hazard Analysis. One table has many lookup fields. Several fields are ID's from other tables. The id's are set to auto fill and are also hidden in table view and detail view. I simply need them for reference to their parent tables in the database.
When these lookup auto fill fields are not hidden, everything works beautifully. However, as soon as I hide them, they stop populating the database. Un hide them and they resume populating the database.
I reverted back to version 5.97 and everything works beautifully when the fields are hidden.
Since I have things working in 5.97, I'm not too worried about it. But I would like to use the most recent versions to take advantage of improvements.
I have an app for writing Job Hazard Analysis. One table has many lookup fields. Several fields are ID's from other tables. The id's are set to auto fill and are also hidden in table view and detail view. I simply need them for reference to their parent tables in the database.
When these lookup auto fill fields are not hidden, everything works beautifully. However, as soon as I hide them, they stop populating the database. Un hide them and they resume populating the database.
I reverted back to version 5.97 and everything works beautifully when the fields are hidden.
Since I have things working in 5.97, I'm not too worried about it. But I would like to use the most recent versions to take advantage of improvements.