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.