Dependent Combobox entries disappear on form when scrolling through records

[RuralGuy]

You are welcome my dear!

 

[NiyiO]

Thanks guys - so basically it was running the lookup on the name as opposed to the ID? Amended it and it works perfectly.

So from what the article is saying - is it better to not have lookups in the table and just create a combo in the form field?

Thanks a lot for your help!

 

[melanie]

NiyiO, that is correct, from what I have been reading it is better not to have the lookup fields on the table.

Regards
Melanie

 

[RuralGuy]

Basically, Lookup fields simply confuse the programmer.