Good day! Create a database in MS Access: there are a number of problems. It is impossible to create a subform "General" + "hardware Type" + "checking Out". If I understand correctly, this is for the reason that there are ties 1-1, not 1-many. Begs the question: how can I change the table to obtain the necessary shape and form submission?
You need to one type of equipment from table "Type of equipment" had a lot of rows from the table, "General", but the option is one-to-many not available for selection. Similarly with table relationships "Departure" and "General".
A similar connection must also have "Shared" with the "Depot", but not out.
The essence of the table: the company database, coordinating between maintenance and depot. Each depot is a piece of equipment (two depot can be two identical) and each depot is a specific RMC. I.e. one of the depot can be only in one RMC. Also, for every depot is fixed your repairman, which can go to other depot, but this depot leaves only him.