Dear Richard, I have to create a company registry database for my staff to use (Customer, Companies, Directors, Shareholders and Beneficial Owners), similar to your automobile tech help video.

1.I want to create a form with vertical navigational bar for company/directors/shareholders/BO. Is it possible that when I open the form (company), the other 3 forms will simultenously show the related records for that company when I click them on the navigation bar?
2.Search Bar for company name in horizontal navigation bar: is it possible to be a combo box with drop down arrow, AND an autocomplete if I start typing in the first letters of the company name?
3.I want to create queries to use as a mail-merge source for documents. I use a lot of Helper Tables like for country. Is there a way for the country name to appear on the query instead of a number from Helper Table?

(PS  I do have a menu form like yours for Customer and Companies, but because of large amount of data and fields neccessary, I had to opt for forms with navigation)

Do you have suggestions on how I can make this work?

Many thanks!!
Jean-Pierre (Seychelles)