1. Suppliers Table - shows 3 suppliers id's and names. I presume, because those two information are in the same table, access "knows" that supplier ID 1 is S, ID 2 is N
2.Input-Supplier-Name shows what method I used for that specific field data entry.
3.Relationship, shows relationships between tables.
4.Inventory table - shows fields Supplier name and ID supplier are not updated. When I shoose Supplier Name, ID supplier is not automatically updated. Belonging to the same table, I thought, that it will be updated by itself.
Most probably, for somebody experianced, this will sound bizzare, but, for me it is a challenge.
The Idea was, when I chooseSupplier name in Inventory table, the field Supplier ID would updated.