1

Topic: ms access 2016 bound fields with lists

Hello , only I study therefore for methods and a statement I ask not to rush . There was a problem.
There are 3 tables and the form. "Shops", "books", "the Registration of sales" and the form for the registration of sales.
In the registration values from "shops" and "books" by a principle shop are substituted: the book.
How to make so that in the field "book" of the form for the Registration of sales which such values stole up only are not present in the registration, i.e. is admissible there is a record "1": "1" and at the following record of the same type with the same shop in the drop down list for books was not "1", but there were other books, except "1" from "the book" table.
Tried to make a turn <> [Forms]! [The Registration of sales]! [Shop] but so books only within the registration are selected and value repeat, even with grouping. In advance thanks.

2

Re: ms access 2016 bound fields with lists

, here itself
https://yadi.sk/d/Y72Tnf7y3YfFye

3

Re: ms access 2016 bound fields with lists

Now there in the field "book" of the form of the registration those records which steal up only exist in the registration on the specified shop, it is necessary to make somehow reverse that were displayed only what else are not present in the registration, but is in the table with books

4

Re: ms access 2016 bound fields with lists

;
Thanks, huge. I am not so good in sql that to such to guess. Rescued literally.