Hello, I'm currently creating the finishing touches a database i've been working on for a while now. I created a search form that I believe is very user friendly thanks to Allen Browne's tutorials.
I ran into a small issue however. When searching fields in my form that are foreign keys, it simply does not work. One way around this is modifying the primary keys from the foreign tables into text format and remove the autoId primary key fields but that would be poor design.
By any chance would anyone know how to solve this? I've attached a copy of my database and if you look at the form that opens up (which is the form im testing right now) you can try to search any field in that form exept for fields that are primary keys.
Thanks in advance for your help.
I ran into a small issue however. When searching fields in my form that are foreign keys, it simply does not work. One way around this is modifying the primary keys from the foreign tables into text format and remove the autoId primary key fields but that would be poor design.
By any chance would anyone know how to solve this? I've attached a copy of my database and if you look at the form that opens up (which is the form im testing right now) you can try to search any field in that form exept for fields that are primary keys.
Thanks in advance for your help.
