Specs: Windows 10, Libre v7, HSQLDB Embedded
Based on the following relationships as shown in the picture below, I have Company and Contact linked to Management which is then linked to Projects. In my form, I want to pick the ManagementID based off the Company name and Contact name. I know I could create a view or query that can show the combinations and then just have open in another window while filling out my Projects form to copy the id. However, I would like to not do that and just have a list box or combo box that shows the combinations in the form. Is there a way to do this?