M
M
MeroVingeR2014-07-13 18:19:55
Microsoft Access
MeroVingeR, 2014-07-13 18:19:55

How to implement relationships between tables in Access?

The Access database contains the following tables:
Client (fields: code, Surname, First Name, Patronymic);
Documents (fields: code, document number, document date, document type)
Summary (fields: code, Client's full name, document data, notes)

Task
It is necessary to implement links between tables so that the following fields are calculated using the formulas:
Summary."Client's full name " = Client.Last name +" "+ Client.First name +" "+ Client.Patronymic
Summary."document data" = "document number" + Documents."document number"+" from "+ Documents."document date" +" type: "+ Documents." document date".

The number of rows in all tables is the same.
I tried to add the fields "Customer's full name" and "document data" to the tables Client and Documents and set up the "transfer" of data to the corresponding fields of the Summary table, but I understand what I'm doing wrong.

PS The question is childish, but my eye is already "blurred".

UPD:
And how to calculate the values ​​in the fields "document data" and "Client's full name" in the Summary table so that they would be displayed normally and how to fill in the Summary. "Notes" field if I need to specify in it: "gr" + Client. " Surname" + "created document number" + Documents. "document number"?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
Spetros, 2014-07-13
@MeroVingeR

The code field is a unique identifier, it must be linked by it.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question