I’m new to databases. I have created a simple database in access that has 4 tables and a simple 1to1 relationship between tables 1&2 and tables 3&4. Now what I need is a frontend so that a user can enter the known info from table 1 and table 3 and have it populate the relational data from tables 2&4 into a formula and display the answer. Can this be done with access or am I barking up the wrong tree in design period.
