Linking the beginnings of books

[zozo.zead]

Welcome


I have a schedule of movements (Move)
I have four tables (BookIn - BookOut _ MsgIn - Msg Out)
There is a need to link the four accounts together in case there is a response to one of the existing book numbers

For example, create a text box for linking in which the desired book number, which is located in one of the four tables, is placed



Example: There is a book in the BookIn table with the number 2, which is a response to a book in MsgOut with the number 3
They must be linked together, and there is a button called the firsts. When you click on it, all the linked correspondence appears, and it may reach a large number, such as a response or an answer.

[June7]

You are not linking the In and Out tables on designated primary key field. If you don't want to use ID fields as key then don't designate them as such.

Exactly what do you mean by "account"?

Should unit "Hosbital" be spelled "Hospital"?

[zozo.zead]

Yes its "hospital" I was in a hurry

I mean the "accounts" are the for table sorry for that

[zozo.zead]

You are not linking the In and Out tables on designated primary key field. If you don't want to use ID fields as key then don't designate them as such.

Exactly what do you mean by "account"?

Should unit "Hosbital" be spelled "Hospital"?

How can i designate ?
There is a relationship between the four tables and the main table
Is it possible to link the four tables to each other again using a link number?

[June7]

Designate primary key field in table design.

I don't understand "link the four tables to each other". The four tables have relationship to main table. Why would they have relationship to each other? Sorry, not understanding your data.

[zozo.zead]

There are 4 types of correspondence
bookout is an issued book
bookin is an incoming book
msgout is an outgoing message
msgin is an incoming message

When I export the first outgoing book and there is a response to an incoming book, they must be linked together

In short, the operations here consist of replying and responding to correspondence

For example, I exported a new book bearing the number 3 on a specific date and the response to it was number 5. An incoming book and I responded to it with a message number 11 on a specific date. Likewise, these three correspondences are each in a table, so a special link number must be set to link the correspondence priorities together.

[mike60smart]

Hi

You need to rethink trying to do everything in one Table.

You should use a Main Form to allow you to select a Specific Book and then link this
to a Main Form listing all of the Transactions for that Book

[June7]

As designed, these 4 tables have no relationship to each other, as far as I can see.

The sample data does not include messages numbered 5 and 11.

Sorry, can't make any sense of what you want to accomplish.

[ArviLaanemets]

Agreeing with others here, that it is impossible to understand, what your database must do!

Maybe start with explaining, what are your objects there. Are they books, like books in library, which are taken and returned by clients form one of 4 desks? Or are they bookings e.g. for rooms in hotel, where clients are booking in or out at one of 4 desks?