I have a lot of foreign keys in a database of which some tables have more than 300000 records. What is happening is that if a link to add a record is selected it takes a long time before the form appears because all the cross referencess in the IS_IN_DB-dropdowns have to be assembled.
How do I speed the process up? Regards Johann -- May grace and peace be yours in abundance through the full knowledge of God and of Jesus our Lord! His divine power has given us everything we need for life and godliness through the full knowledge of the one who called us by his own glory and excellence. 2 Pet. 1:2b,3a