Access how to simplify your work?

Question

Microsoft Access

Hello, I am working in the access program and creating a database.
I have 2 tables. The Customer table and the Orders table.
The Customer table has a Full Name and Address field
. The Orders table has the same.
Question! How can I make it so that in the Orders table, when choosing the full name of the buyer, his address is automatically selected and put?

Answer 1

Remove the fuck from the table Orders full name and address of the user. Insert Id_FIO, Id_Address there.
Make foreign kei on the appropriate fields.
Homework: Think about what to do if two Ivanov Ivan Ivanovich accidentally appear in the database.